Question

sql server语句中的while用法

假使变量x的初始值为1，每次加1，直至x的值变为3，显示x的所有值
{使用while语句}

我们老师让做，我不会，希望各位朋友们帮助一下，我好借此学会这样用法

Answer 1

执行以下下面代码。这样就可以了。

declare @x int
set @x = 1
while(@i <= 3)
begin
set @x = @x + 1
print @x
end

Answer 2

SQL中最常见的实例：
DECLARE @Name nvarchar(20);
DECLARE @Type varchar(20);
DECLARE @Count int ;
DECLARE @IsCommend bit ;
DECLARE @IsStatic bit ;
set @Name ='asp,php,asp.net,jsp'
set @Type ='asp,php,asp.net,jsp'
set @Count =0
set @IsCommend ='false'
set @IsStatic ='true'
DECLARE @Names nvarchar(500);
DECLARE @Types nvarchar(100);
DECLARE @t1 nvarchar(10);
DECLARE @n1 nvarchar(10);
set @Names = @Name+ ','
set @Types = @Type+ ','
declare @i int;
set @i=0
BEGIN TRY
--BEGIN TRAN
while CHARINDEX(',',@Types)>0
begin
SELECT @t1=LEFT(@Types,CHARINDEX(',',@Types+',')-1),@Types=STUFF(@Types,1,CHARINDEX(',',@Types+','),'')
while CHARINDEX(',',@Names)>0
begin
SELECT @n1=LEFT(@Names,CHARINDEX(',',@Names+',')-1),@Names=STUFF(@Names,1,CHARINDEX(',',@Names+','),'')
INSERT INTO W_Keyword ([Name], [Type], [Count], IsCommend, IsStatic,EditDate)
VALUES (@n1,@t1, @Count, @IsCommend, @IsStatic,GetDate())
end
set @Names = @Name+ ','
end
--COMMIT TRAN
END TRY
BEGIN CATCH
ROLLBACK TRAN
DECLARE @MESSAGE NVARCHAR(4000)
SELECT @MESSAGE = ERROR_MESSAGE()
RAISERROR(@MESSAGE, 16, 1)
END CATCH

Answer 3

同上