Insert into B(name,no)
Select Name,startno
from A
union all
Select Name,endno
from A
Select Name,startno
from A
union all
Select Name,endno
from A
解决方案 »
- T-SQL 正则表达式(CLR 实现)
- 链接数据库表结构变更后问题
- 将2000升级到2005的数据库的兼容级别由80->90对原来的设计有影响吗?
- 触发器问题
- 我要查询符合我条件的前n条记录该怎么写啊?帮我看看哪里有错,谢谢!!!
- 怎样利用PowerDesign文件直接建库
- 如果返回的记录数都是1,那么模糊查询与精确查询的效率差多少?内有例程 ↓↓
- SQL Server2000 int数据类型自增问题,gz,up 有分
- 再次询问数据库开发网址,分数增加中...
- SELECT @n1=COUNT(1) FROM deposit_temp 这里的返回记录数不会把值给变量@n1啊
- 100分求教树型结构分层问题,急
- 记录查询问题..
declare @i int
declare @a1 int
declare @a2 int
declare @name varchar(20)open tb
fetch next from tb into @name,@a1,@a2
while @@fetch_status=0
begin
set @i = @a1
while (@i <= @a2)
begin
INSERT tableb (name,no) VALUES(@name,@i)
s et @i = @i + 1
end fetch next from tb into @name,@a1,@a2
end
close tb
deallocate tb
Select name,a.startno+b.id as no
from 表A as a left join #t as b on id <=a.endno-a.startno
--------------------------------那就多产生行数,那就用交叉
Select id=identity(int,0,1) into #t from syscolumns as a,syscolumns as b