sql server 中游标的简单使用
DECLARE myCur CURSOR FOR SELECT id FROM kf_customer_infos OPEN myCurFETCH NEXT FROM myCurWHILE(@@FETCH_STATUS<>-1)BEGIN //do something FETCH NEXT FROM myCurENDCLOSE myCurDEALLOCATE myCur --定义游标(动态)EXEC(DECLARE myCur CURSOR FOR +@temSQL) 例：USE [bhis_fc_360009081027801]GO/****** 对…
查看全文
