摘要:
CREATE PROCEDURE procedureName (@var1 as varchar(50),@var2 as varchar(50))--建立未发临时表ASbegin tran--doSthDUMP TRANSACTION GJJ WITH NO_LOG ---------1.清空日志... 阅读全文
摘要:
//遍历tmp_check的年份和月份DECLARE @year as varchar(4)DECLARE @month as varchar(2)DECLARE cur CURSOR FOR SELECT nf,yf FROM tmp_check;OPEN cur fetch next from ... 阅读全文