← Back to branch summary

~halega/+junk/sqlinstaller

« back to all changes in this revision

Viewing changes to SQLInstaller.Sample/Scripts/SqlServer/Install/StoredProcedures/EmployeesInsert.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/EmployeesInsert.StoredProcedure.sql
 
1
 
 
2
CREATE PROCEDURE EmployeesInsert
 
3
(
 
4
        @EmployeeID decimal(10,0) = NULL output,
 
5
        @LastName nvarchar(20),
 
6
        @FirstName nvarchar(10),
 
7
        @Title nvarchar(30) = NULL,
 
8
        @TitleOfCourtesy nvarchar(25) = NULL,
 
9
        @BirthDate datetime = NULL,
 
10
        @HireDate datetime = NULL,
 
11
        @Address nvarchar(60) = NULL,
 
12
        @City nvarchar(15) = NULL,
 
13
        @Region nvarchar(15) = NULL,
 
14
        @PostalCode nvarchar(10) = NULL,
 
15
        @Country nvarchar(15) = NULL,
 
16
        @HomePhone nvarchar(24) = NULL,
 
17
        @Extension nvarchar(4) = NULL,
 
18
        @Photo image = NULL,
 
19
        @Notes ntext = NULL,
 
20
        @ReportsTo decimal(10,0) = NULL,
 
21
        @PhotoPath nvarchar(255) = NULL,
 
22
        @UserID nvarchar(255),
 
23
        @AuthUserID nvarchar(255)
 
24
)
 
25
AS
 
26
BEGIN
 
27
 
 
28
        SET NOCOUNT OFF
 
29
        EXEC SetUserContext @AuthUserID
 
30
        DECLARE @Err int
 
31
 
 
32
        INSERT
 
33
        INTO Employees
 
34
        (
 
35
                LastName,
 
36
                FirstName,
 
37
                Title,
 
38
                TitleOfCourtesy,
 
39
                BirthDate,
 
40
                HireDate,
 
41
                Address,
 
42
                City,
 
43
                Region,
 
44
                PostalCode,
 
45
                Country,
 
46
                HomePhone,
 
47
                Extension,
 
48
                Photo,
 
49
                Notes,
 
50
                ReportsTo,
 
51
                PhotoPath,
 
52
                UserID
 
53
        )
 
54
        VALUES
 
55
        (
 
56
                @LastName,
 
57
                @FirstName,
 
58
                @Title,
 
59
                @TitleOfCourtesy,
 
60
                @BirthDate,
 
61
                @HireDate,
 
62
                @Address,
 
63
                @City,
 
64
                @Region,
 
65
                @PostalCode,
 
66
                @Country,
 
67
                @HomePhone,
 
68
                @Extension,
 
69
                @Photo,
 
70
                @Notes,
 
71
                @ReportsTo,
 
72
                @PhotoPath,
 
73
                @UserID
 
74
        )
 
75
 
 
76
        SET @Err = @@Error
 
77
 
 
78
        SELECT @EmployeeID = SCOPE_IDENTITY()
 
79
 
 
80
        RETURN @Err
 
81
END
 
82
GO
 
83