存储过程.返回插入行的id

[sql]代码库

USE [VoteDB]
GO
/****** Object:  StoredProcedure [dbo].[VoteBasicInfo_Insert]    Script Date: 2015/5/18 16:04:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
Create PROCEDURE [VoteBasicInfo_Insert]
(
	@ptitle nvarchar(200),
	@pcontent nvarchar(500),
	@pabstention bit,
	@pdeadline datetime
)
AS
declare @resultid int
BEGIN
	insert into VoteBasicInfo (VTitle,VContent,VAbstention,VDeadline) values(@ptitle,@pcontent,@pabstention,@pdeadline)
	select @resultid=@@IDENTITY
END
return @resultid