WHILE (Transact-SQL)---循环declare @n intdeclare @rowcount int declare @name varchar(50)create table #temp( id int identity(1,1), ColumnNme nvarchar(100))insert into #temp select COLUMN_NAME from 数据库名.INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='表名' --表名set @rowcount=@@rowcountset @n=1while @n<@rowcountbegin select @name=ColumnNme from #temp where id=@n PRint('strSql.Append("'+@name+'=@'+@name+',");') set @n=@n+1enddrop table #temp--游标declare @name nvarchar(max)declare geovindu_cursor cursor for select COLUMN_NAME from 数据库名.INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='表名' --表名open geovindu_cursorfetch next from geovindu_cursor into @namewhile(@@fetch_status=0)begin print('strSql.Append("'+@name+'=@'+@name+',");') fetch next from geovindu_cursor into @nameendclose geovindu_cursordeallocate geovindu_cursor--ms sql里的控制字符列表：--Tab char(9)--换行char(10)--回车char(13)--单引号char(39)--双引号char(34)WHILE (SELECT AVG(ListPrice) FROM Production.Product) < $300BEGIN UPDATE Production.Product SET ListPrice = ListPrice * 2 SELECT MAX(ListPrice) FROM Production.Product IF (SELECT MAX(ListPrice) FROM Production.Product) > $500 BREAK ELSE CONTINUEENDPRINT 'Too much for the market to bear';