sql server 有WHILE语句,语法如下:WHILE Boolean_expression
{ sql_statement | statement_block }
[ BREAK ]
{ sql_statement | statement_block }
[ CONTINUE ]
{ sql_statement | statement_block }
[ BREAK ]
{ sql_statement | statement_block }
[ CONTINUE ]
sql本身好像没这个功能
select @a=0
select top 100 @a=@a+1 from table /*run 100 ci */
select @a /* @a=100 */
好像可以实现简单的循环,不过这个100不知怎么用变量表达