How to create script in sql server? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 2

How to create script in sql server?

i want to create a script in sql server for using for and if in my query

1st Oct 2018, 12:48 PM
Amir Rafati
Amir Rafati - avatar
3 Answers
+ 13
declare @counter int = 0; while @counter < 10 begin if @counter = 5 break; else select getdate() set @counter = @counter+1; end;
2nd Oct 2018, 7:36 AM
r8w9
r8w9 - avatar
+ 1
thanks
2nd Oct 2018, 1:24 PM
Muhammad Rafique
Muhammad Rafique - avatar
0
where are you r8w8
2nd Oct 2018, 1:25 PM
Muhammad Rafique
Muhammad Rafique - avatar