好的 给个数据实例 数据量很大的那种,就是游标很费时的DECLARE CURID CURSOR FOR SELECT ID FROM TABLENAME OPEN CURID DECLARE @ID NVARCHAR(50) FETCH NEXT FROM CURID INTO @ID WHILE @@FETCH_STATUS = 0 BEGIN UPDATE\INSERT\DELETE\SELECT 等操作 FETCH NEXT FROM CURID INTO @ID END CLOSE CURID DEALLOCATE CURID
表连接具体做法待解决
SELECT ID FROM TABLENAME
OPEN CURID
DECLARE @ID NVARCHAR(50)
FETCH NEXT FROM CURID INTO @ID
WHILE @@FETCH_STATUS = 0
BEGIN
UPDATE\INSERT\DELETE\SELECT 等操作
FETCH NEXT FROM CURID INTO @ID
END
CLOSE CURID
DEALLOCATE CURID