--新建存储过程,向新闻表插入一条数据,并返回自动生成的最大编号
create proc pro_GerMaxId
@maxid INT OUT
AS
INSERT INTO T_News
(NewsTitle,NewsContent,NewsCreator,CreateTime,ClassId)
VALUES
('本周全国大部分地区降温','本周全国大部分地区降温,最高降温达°','003',GETDATE(),'39ec3206-4467-44b4-8fa1-711443eb4ce5');
set @maxid=@@IDENTITY;
go
declare @maxid INT;
exec Pro_GerMaxId @maxid OUT;
PRINT @maxid;
select * from T_News
--接受用户输入的参数,插入数据,返回最大编号
create proc Pro_GetMaxId1
@newstitle VARCHAR(64),
@newscontent VARCHAR(max),
@newscreator VARCHAR(8),
@createtime DATETIME,
@classname VARCHAR(8),
@maxid INT OUT
AS
DECLARE @classid uniqueidentifier;
select @classid=T1.ClassId from T_NewsClass
T1 where T1.ClassName=@classname;
INSERT INTO T_News(NewsTitle,NewsContent,NewsCreator,CreateTime,ClassId)
VALUES
(@newstitle,@newscontent,@newscreator,GETDATE(),@classid);
SET @maxid=@@IDENTITY;
GO