sqlserver怎么创建存储过程
6个回答
展开全部
IF EXISTS
(SELECT 1
FROM sysobjects
WHERE name = 'deletetenews' AND type = 'p')
DROP PROCEDURE deletetenews
go
CREATE PROCEDURE deletetenews(@xwbm CHAR(14), @typeid CHAR(2) OUTPUT, @picurl VARCHAR(100) OUTPUT)
AS
BEGIN
SET NOCOUNT ON;
SELECT @typeid = s.typeid,
@picurl = s.picurl
FROM tb_news s
WHERE s.xwbm = @xwbm; --返回类型编码重新生成JS文件
DELETE FROM tb_news
WHERE xwbm = @xwbm;
SET NOCOUNT OFF;
END
*/
(SELECT 1
FROM sysobjects
WHERE name = 'deletetenews' AND type = 'p')
DROP PROCEDURE deletetenews
go
CREATE PROCEDURE deletetenews(@xwbm CHAR(14), @typeid CHAR(2) OUTPUT, @picurl VARCHAR(100) OUTPUT)
AS
BEGIN
SET NOCOUNT ON;
SELECT @typeid = s.typeid,
@picurl = s.picurl
FROM tb_news s
WHERE s.xwbm = @xwbm; --返回类型编码重新生成JS文件
DELETE FROM tb_news
WHERE xwbm = @xwbm;
SET NOCOUNT OFF;
END
*/
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
|
广告 您可能关注的内容 |
