这个存储过程要怎么改
山野市民 2011-05-17 05:43:58 createPROCEDURE [dbo].[CreateTrackLogTablePR]
(
@TerID INT
)
AS
----开始事务----
BEGIN TRANSACTION
---- 声明变量 ----
DECLARE @SqlStr VARCHAR(2000)
BEGIN
SET @SqlStr=N'SELECT * INTO Sys_TrackLogTB_'+@TerID +' FROM Sys_TrackLogTB where 1<>1'
exec @SqlStr
END
IF @@ERROR > 0
BEGIN
rollback transaction
--回滚
END
ELSE
BEGIN
commit transaction
--提交
END
RETURN