← Back to branch summary

~halega/+junk/sqlinstaller

« back to all changes in this revision

Viewing changes to SQLInstaller.Sample/Scripts/SqlServer/Install/StoredProcedures/SuppliersSelect.StoredProcedure.sql

  • Committer: sk
  • Date: 2011-09-10 05:32:36 UTC
  • Revision ID: halega@halega.com-20110910053236-1877r3p0k4a64bgx
Tags: 1.2.2
1.2.2

Show diffs side-by-side

added added

removed removed

Lines of Context:
SQLInstaller.Sample/Scripts/SqlServer/Install/StoredProcedures/SuppliersSelect.StoredProcedure.sql
 
1
 
 
2
CREATE PROCEDURE SuppliersSelect 
 
3
AS
 
4
BEGIN
 
5
 
 
6
        SET NOCOUNT ON
 
7
        DECLARE @Err int
 
8
 
 
9
        SELECT
 
10
                SupplierID,
 
11
                CompanyName,
 
12
                ContactName,
 
13
                ContactTitle,
 
14
                Address,
 
15
                City,
 
16
                Region,
 
17
                PostalCode,
 
18
                Country,
 
19
                Phone,
 
20
                Fax,
 
21
                HomePage
 
22
        FROM Suppliers
 
23
        
 
24
        
 
25
        SET @Err = @@Error
 
26
 
 
27
        RETURN @Err
 
28
END
 
29
GO
 
30