Stored Procedure Properties
Name | Value |
---|---|
Owner | dbo |
Created | 2004-05-31 |
Startup | False |
Encrypted | False |
Creation Options
Name | Value |
---|---|
QUOTED_IDENTIFIER | ON |
ANSI_NULLS | ON |
Parameters
Name | DataType | Length | Type |
---|---|---|---|
@PostID | int | 4 | INPUT |
@Vote | nvarchar | 4 | INPUT |
Total: 2 parameter(s)
SQL
SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO create procedure forums_Vote ( @PostID int, @Vote nvarchar(2) ) AS IF NOT EXISTS ( SELECT PostID FROM Vote WHERE PostID = @PostID AND Vote = @Vote ) BEGIN -- Transacted insert for download count BEGIN TRAN INSERT INTO Vote VALUES ( @PostID, @Vote, 1 ) COMMIT TRAN END ELSE BEGIN -- Transacted update for download count BEGIN TRAN UPDATE Vote SET VoteCount = VoteCount + 1 WHERE PostID = @PostID AND Vote = @Vote COMMIT TRAN END GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO