摘要:
--变量声明默认是Null Valuedeclare @groupid int if(@groupid is null) print 'group id is null' 阅读全文
摘要:
--开始事务BEGIN TRAN--不显示计数信息SET NOCOUNT ONdeclare @companyid intdeclare @personid intdeclare OuterCursor cursorfor --tim select personid,companyid from company where employeeid in(2000000043)open OuterCursor fetch next from OuterCursor into @personid,@companyid while(@@fetch_status=0) begin -- do work 阅读全文