SQL Server 批量创建表 - MS-SQL Server / 基础类

SQL code:

/*下面循环创建有误，第一行 '4' 附近有错误*/
declare @ii int
set @ii = 4
while @ii <= 100000
begin
declare @strSql varchar(100)
declare @_str varchar(10)
set @_str = str(@ii)
set @strSql = 'create table dd_tb_'+ @_str + ' (tm datetime,tagValue float)'
set @ii = @ii + 1
execute(@strSql)
end

/*这个正确：*/
declare @ii varchar(10)
set @ii = '4'
/*while @ii <= 100000*/
begin
declare @strSql varchar(100)
/*declare @_str varchar(10)
set @_str = str(@ii)*/
set @strSql = 'create table dd_tb_'+ [color=#FF0000]@ii[/color] + ' (tm datetime,tagValue float)'
/*set @ii = @ii + 1*/
execute(@strSql)
end



很明显是因为 @ii 是int的原因，int如何转换成字符串呢？

---

SQL code:
set @strSql = 'create table dd_tb_'+ ltrim(@ii) + ' (tm datetime,tagValue float)'
/*set @ii = @ii + 1*/
execute(@strSql)
end

---

SQL code:
set @strSql = 'create table dd_tb_'+ ltrim(@ii)+ ' (tm datetime,tagValue float)'

---

set @_str = str(@ii)

-->

set @_str = ltrim(@ii)
set @_str = cast(@ii as varchar)

---

引用

SQL code
set @