添加条记录返回主键值
2010-03-10 15:08 三皮开发时 阅读(273) 评论(0) 收藏 举报
-- 插入一行数据,返回主键ID值。
ALTER PROCEDURE dbo.BlogMainNew
(
@title nvarchar (100),
@content text
)
AS
Insert Into BlogMain (title, content) values (@title, @content);
Select @@IDENTITY;
RETURN
ALTER PROCEDURE dbo.BlogMainNew
(
@title nvarchar (100),
@content text
)
AS
Insert Into BlogMain (title, content) values (@title, @content);
Select @@IDENTITY;
RETURN
浙公网安备 33010602011771号