直接执行文件中的语句即可创建存储过程。 CREATE PROCEDURE [createReDealCheck] -- Add the parameters for the stored procedure here AS BEGIN declare @Cur_Error as integer set @Cur_Error = 0 BEGIN TRANSACTION Tran_1 -- SET NOCOUNT ON added to prevent extra result sets from
存储过程名:包括页面后台代码和触发器和数据库连接类都有了,并且经过测试完全正确。 ChannelSet_MoveUP(上移) CREATE procedure [dbo].[ChannelSet_MoveUP] @ChannelID INT as DECLARE @SortID int DECLARE @TempSortID INT DECLARE @TempID INT BEGIN TRAN SELECT @SortID=SortID from ChannelSet where Channe