← Back to branch summary

~halega/+junk/sqlinstaller

« back to all changes in this revision

Viewing changes to SQLInstaller.Sample/Scripts/SqlServer/Install/StoredProcedures/OrdersDelete.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/OrdersDelete.StoredProcedure.sql
 
1
 
 
2
CREATE PROCEDURE OrdersDelete
 
3
(
 
4
        @OrderID decimal(10,0),
 
5
        @AuthUserID nvarchar(255)
 
6
)
 
7
AS
 
8
BEGIN
 
9
 
 
10
        SET NOCOUNT OFF
 
11
        EXEC SetUserContext @AuthUserID
 
12
        DECLARE @Err int
 
13
 
 
14
        DELETE
 
15
        FROM Orders
 
16
        WHERE
 
17
                OrderID = @OrderID
 
18
        SET @Err = @@Error
 
19
 
 
20
        RETURN @Err
 
21
END
 
22
GO
 
23