怎样在Sql server中创建,执行和删除存储过程

2025-03-24 01:01:40
推荐回答(1个)
回答1:

sqlserver manage 工具有个好的东西就是右键,编写脚本创建、删除、修改到。。。。CREATE PROCEDURE [dbo].[PU]
@GP CHAR(1) output
AS
DECLARE @TMPDATE datetime,@NUM int
BEGIN
END

ALTER PROCEDURE [dbo].[PU]
@GP CHAR(1) output
AS
DECLARE @TMPDATE datetime,@NUM int
BEGIN
END

DROP PROCEDURE [dbo].[P_HW_GONGPU]