CREATE PROCEDURE insert_voteItem @root NUMERIC(9),@title varchar(50),@voteUser varchar(50)
AS
SET NOCOUNT OFF
IF NOT EXISTS(SELECT TOP 1 * FROM vote Where voteTitle=@title AND deleted=0)
BEGIN
IF @voteUser is NULL
INSERT vote (rootid,type,voteTitle) VALUES (@root,1,@title)
ELSE
BEGIN
INSERT vote (rootid,type,voteTitle,voteUser,voteNum) VALUES (@root,1,@title,@voteUser,1)
SELECT SCOPE_IDENTITY()
INSERT voteUser (voteId,username,rootId) VALUES (@voteId,@voteUser,@root)
END
END
SET NOCOUNT ON
GO