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 |
Total: 1 parameter(s)
SQL
SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE procedure forums_GetVoteResults ( @PostID int ) AS BEGIN SELECT Vote, VoteCount FROM Vote WHERE PostID = @PostID END GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO