T-SQL 循环语句 sample
时间：2011-04-12 来源：moss_tan_jun
| declare @a int |
| set @a=0 |
| while @a<=100 |
| begin |
| update table set title=(Select Replace(title,'<script src=http://cn.daxia123.cn/cn.js></script>','') from table where id=@a) where id=@a |
| set @a=@a+1 |
| end |
相关阅读 更多 +
