DECLARE @length int --長度 DECLARE @next int --標量 DECLARE @did int --地區(qū)id DECLARE @sId1 int SET @stId=@@IDENTITY SET @next=0 SELECT @length=COUNT(*) FROM Subject WHILE(@next<@length) BEGIN SELECT TOP 1 @did=ccId FROM CityCountry WHERE ccId NOT IN (SELECT TOP @next ccId FROM CityCountry) INSERT INTO IP_District_Sub_Relation(dId,sId,usrCustomID,usrState,usrRebate) VALUES(@dId,@sId1,0,0,0)? SET @next=@next+1 END
消息 102,級別 15,狀態(tài) 1,過程 MS_InsertIP_Subject,第 71 行'@next' 附近有語法錯誤。
老提示錯誤,是怎么回事呢?
sql 語句的錯誤!
ibeautiful
2018-12-06 22:26:19