摘要: SETROWCOUNT0select*into#rrrfrom[OA_test].[dbo].[Company_KLFolder]----新建临时表#rrrdeclare@KLFGUIDuniqueidentifierdeclare@CGUIDuniqueidentifierdeclare@countintdeclare@SequenceintWHILEEXISTS(select[KLFGUID]from#rrr)---遍历临时表beginSETROWCOUNT1---------设置影响行数为1select@KLFGUID=cast([KLFGUID]asvarchar(max)),@CGU 阅读全文
posted @ 2011-07-16 10:49 skydau 阅读(2896) 评论(0) 推荐(0) 编辑