1,建序数表
select top 8000 identity(int,1,1) as N into numtab from
(select top 100 id=1 from sysobjects) as a,
(select top 100 id=1 from sysobjects) as b,
(select top 100 id=1 from sysobjects) as cselect * from numtab
select top 8000 identity(int,1,1) as N into numtab from
(select top 100 id=1 from sysobjects) as a,
(select top 100 id=1 from sysobjects) as b,
(select top 100 id=1 from sysobjects) as cselect * from numtab
解决方案 »
- 装哪个版的SQL Server 2005 才能出现management studio
- 数据库名称问题
- BULK INSERT 库名..表名 问题
- 求一条sql语句,想了几天没想出来
- 有几种办法可以使通过局域网上网的机器能得到独立的IP地址?
- 如何把服务器名把由"CHEYO\CHEYO"改为"CHEYO"????
- 如何将ODBC数据源从控制面板中隐藏起来,谢谢!
- MS SQL Server 中,怎样由MySchool.mdf和MySchool.ldf两个文件恢复数据库MySchool?
- ADO数据绑定记录死活插不进数据库
- 如何控制触发器的互相触发???
- 在SQL中null加上什么值都等于null,有什么函数可以将null变成0
- 存储过程关于返回单个值的问题
alter function fmerg(@id int)
returns varchar(8000)
as
begin
declare @str varchar(8000)
declare @i int
set @str=''
set @i = 1
while @i <= @id
begin
set @str=@str+','+cast(@i as varchar)
set @i = @i+1
end
set @str=right(@str,len(@str)-1)
return(@str)
End
go--调用 Select dbo.fmerg(10) 结果为: 1,2,3,4,5,6,7,8,9,10
select * from #temp
drop table #temp
select * from #temp
drop table #temp