Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Cursor (procedural while)
declare @id int DECLARE i CURSOR FAST_FORWARD LOCAL FOR select Id from Pilots OPEN i FETCH NEXT FROM i INTO @id WHILE (@@fetch_status = 0) BEGIN --do stuff here select @id FETCH NEXT FROM i INTO @id END CLOSE i DEALLOCATE i
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
how-to-assign-a-random-value-in-a-select-statement-in-sqlserver
new
get date part from datetime
Using pre-built schema in sql server
Cine latino
exp7
Sql server 2012 features list
sql_fb
SQL_DS_collections
i need help
Please log in to post a comment.