34,589
社区成员
发帖
与我相关
我的任务
分享
create table tb_IdNameMap
(
tagID int identity(1,1) not null,
tagName varchar(32)
)
insert into tb_IdNameMap values('hehe_0')
declare @i int
declare @strTemp varchar(60)
declare @strSql varchar(200)
set @i = 1
set @strTemp = ''
set @strSql = ''
while @i < 100000
begin
set @strTemp = 'hehe_' + ltrim(@i)
set @strSql = 'insert into tb_IdNameMap values' + '(' + @strTemp + ')'
exec(@strSql)
set @i = @i + 1
end
select * from tb_IdNameMap
create table tb_IdNameMap
(
tagID int identity(1,1) not null,
tagName varchar(32)
)
insert into tb_IdNameMap values('hehe_0')
declare @i int
declare @strTemp varchar(60)
declare @strSql varchar(200)
set @i = 1
set @strTemp = ''
set @strSql = ''
while @i < 100000
begin
set @strTemp = 'hehe_' + ltrim(@i)
set @strSql = 'insert into tb_IdNameMap values' + '(' + quotename(@strTemp,CHAR(39)) + ')'
exec(@strSql)
set @i = @i + 1
end
select * from tb_IdNameMap
或这样也行create table tb_IdNameMap
(
tagID int identity(1,1) not null,
tagName varchar(32)
)
insert into tb_IdNameMap values('hehe_0')
declare @i int
declare @strTemp varchar(60)
declare @strSql varchar(200)
set @i = 1
set @strTemp = ''
set @strSql = ''
while @i < 100000
begin
set @strTemp = 'hehe_' + ltrim(@i)
set @strSql = 'insert into tb_IdNameMap values' + '(''' + @strTemp + ''')'
exec(@strSql)
set @i = @i + 1
end
create table tb_IdNameMap
(
tagID int identity(1,1) not null,
tagName varchar(32)
)
insert into tb_IdNameMap values('hehe_0')
declare @i int
declare @strTemp varchar(60)
declare @strSql varchar(200)
set @i = 1
set @strTemp = ''
set @strSql = ''
while @i < 100000
begin
set @strTemp = 'hehe_' + ltrim(@i)
insert into tb_IdNameMap values(@strTemp)
set @i = @i + 1
end