Sql 循环

declare 
    --创建游标
    cur cursor for select _user,_pwd from userTable;
declare

    @use varchar(20),@pw varchar(20);
    begin
    --打开游标
    open cur;
    --移动游标取值
    fetch next from cur into @use,@pw;
    --这里对游标的状态进行判断，如果为0，证明游标中有值
    while @@FETCH_STATUS = 0
        begin
            print(@use);
            print(@pw);
            --让游标继续往后移动
            fetch next from cur into @use,@pw
        end
    --关闭游标
    close cur;
    deallocate cur;
    end

　　

DECLARE @i INT = 0; --设置循环次数起始值
WHILE @i < 100 --200是循环终止次数
BEGIN
print (@i

​DECLARE @sqlstr nvarchar(max)
/*定义一个变量*/
DECLARE @database_default nvarchar(20) = 'StuInfo';
DECLARE @database_name nvarchar(20) = '';
DECLARE @i INT = 1; --设置循环次数起始值
WHILE @i <= 10 --200是循环终止次数
BEGIN

set @database_name=@database_default+CAST(@i as nvarchar(10));
	--创建数据库
SET @sqlstr= 'CREATE DATABASE'+' '+@database_name+' '
SET @sqlstr+= 'ON'
SET @sqlstr+= '('
SET @sqlstr+= 'NAME='+@database_name+','
SET @sqlstr+= 'FILENAME=''D:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\'+@database_name+'.mdf'','
SET @sqlstr+= 'SIZE=8MB,'
SET @sqlstr+= 'MAXSIZE=UNLIMITED,'
SET @sqlstr+= 'FILEGROWTH=10%'
SET @sqlstr+= ')'
SET @sqlstr+= 'LOG ON'
SET @sqlstr+= '('
SET @sqlstr+= 'NAME='+@database_name+'_log,'
SET @sqlstr+= 'FILENAME=''D:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\DATA\'+@database_name+'_log.ldf'','
SET @sqlstr+= 'SIZE=8MB,'
SET @sqlstr+= 'MAXSIZE=100MB,'
SET @sqlstr+= 'FILEGROWTH=10%'
SET @sqlstr+= ');'


SET @i = @i + 1;
END;

print (@sqlstr)

　　

) SET @i = @i + 1; END;