CREATE PROC Pro_GetNews
AS
SELECT * FROM T_News
GO
EXEC Pro_GetNews
GO
CREATE PROC Pro_GetNewsByTitle
@newstitle VARCHAR(64)
AS
SELECT NewsTitle,SUBSTRING(NewsContent,1,20)+'.....' AS NewsContent,CreateTime FROM T_News
WHERE NewsTitle LIKE @newstitle;
GO
--新建存储过程,向新闻表插入一条数据,并返回自动生成的最大编号
CREATE PROC Pro_GetMaxId
@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_GetMaxId @maxid OUT;
PRINT @maxid;
GO
--接受用户输入的参数,插入数据,返回最大编号
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
--执行存储过程
DECLARE @maxid INT;
EXEC Pro_GetMaxId1
'钓鱼岛,'是中国的领土,'004','1900-01-01','军事',@maxid OUT;
PRINT @maxid;
GO
AS
SELECT * FROM T_News
GO
EXEC Pro_GetNews
GO
CREATE PROC Pro_GetNewsByTitle
@newstitle VARCHAR(64)
AS
SELECT NewsTitle,SUBSTRING(NewsContent,1,20)+'.....' AS NewsContent,CreateTime FROM T_News
WHERE NewsTitle LIKE @newstitle;
GO
--新建存储过程,向新闻表插入一条数据,并返回自动生成的最大编号
CREATE PROC Pro_GetMaxId
@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_GetMaxId @maxid OUT;
PRINT @maxid;
GO
--接受用户输入的参数,插入数据,返回最大编号
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
--执行存储过程
DECLARE @maxid INT;
EXEC Pro_GetMaxId1
'钓鱼岛,'是中国的领土,'004','1900-01-01','军事',@maxid OUT;
PRINT @maxid;
GO