DROP TABLE dbo.Votes_Insert;
CREATE TABLE dbo.Votes_Insert
(
Id INT IDENTITY(1, 1) NOT NULL,
PostId INT NOT NULL,
UserId INT NULL,
BountyAmount INT NULL,
VoteTypeId INT NOT NULL,
CreationDate DATETIME NOT NULL,
CONSTRAINT PK_Votes_Insert_Id
PRIMARY KEY CLUSTERED (Id ASC)
WITH (OPTIMIZE_FOR_SEQUENTIAL_KEY = ON)
);
GO
CREATE PROCEDURE dbo.VoteInserter
AS
SET NOCOUNT, XACT_ABORT ON
BEGIN
INSERT dbo.Votes_Insert ( PostId, UserId, BountyAmount, VoteTypeId, CreationDate )