SQL Server does not have a For loop, but can be replaced by a while loop. The following is an example For your reference. Sample Code for copying: CREATEPROCEDUREAddStudentsASBeginDeclare @ nbigintDeclare @ Sqlnvarchar (225) set @ n0while @ n10000beginSet @ SqlInsertintoSt
SQL Server does not have a For loop, but can be replaced by a while loop. The following is an example For your reference. Code example: create procedure AddStudents AS Begin Declare @ n bigint Declare @ SQL nvarchar (225) set @ n = 0 while @ n10000 begin Set @ SQL = 'insert into St
SQL Server does not haveLoopBut you can useLoopHere is an example for your reference.
Sample Code:
Create procedure AddStudents
Begin
Declare @ n bigint
Declare @ SQL nvarchar (225)
Set @ n = 0
While @ n< 10000
Begin
Set @ SQL = 'insert into Students Values (''hamunet'', 10, ''sianchina', ''100 '')'
Exec (@ SQL)
Set @ n = @ n + 1
End
Another SQL serverLoopAlternative example.
ForLoopProcessing.
Sample Code:
Declare @ itemnumber int -- Definition requiredLoopNumber of times
Declare @ tagint int -- defines the flag field for endLoop
Set @ tagint = 1
Select @ itemnumber = count (distinct Creater) from Demo_TestTable where isnull (Creater, '') <>'' And
DATEDIFF (DAY, CreatDate, GETDATE () <1
If (@ itemnumber> 0)
Begin
While @ tagint <= @ itemnumber
Begin
Waitfor delay '00: 00: 01' -- replace available parameter variables every second
Update Demo_TestTable set CreatDate = GETDATE () where Creater = (
Select Creater from (
Select Creater, ROW_NUMBER () over (order by Creater) as RowID from Demo_TestTable where
Isnull (Creater, '') <>'' And DATEDIFF (DAY, CreatDate, GETDATE () <1 group by Creater
) TableA
Where TableA. RowID = @ tagint
)
Set @ tagint = @ tagint + 1
End
End
LoopThen, the format of yyyy-MM-dd hh: mm: ss: fff in CreatDate is changed to yyyy-MM-dd.
SQL server does not haveLoopIt is good to use while instead.
This article from: script School, reproduced please indicate the source: http://www.jbxue.com/db/6301.html