sql 数据 插入 虚拟表

[为红颜而拔剑]

同一张表，查出来的数据放入一张虚拟表中

select * from SysBill a,VersionModel b where a.ModelId=b.ID

select * from SysBill where ModelId is Null

求帮助，急急急急急，在线等~~~~

[还在加载中灬]

--只要你的内容列能对上
select * INTO #T from SysBill a,VersionModel b where a.ModelId=b.ID

INSERT INTO #T
select * from SysBill where ModelId is Null

[还在加载中灬]

IF OBJECT_ID('#T')IS NOT NULL
DROP TABLE #T
GO
select a.* INTO #T from SysBill a,VersionModel b where a.ModelId=b.ID
 
INSERT INTO #T
select * from SysBill where ModelId is Null

[唐诗三百首]

SQL Server没有虚拟表的概念, LZ可以考虑用临时表,表变量或视图.

[xb8315381]

新手用select * into #B from table 好理解些

[卖水果的net]

如果数据量不大的话，使用表变量吧，和临时表一样简单。

[Tiger_Zhao]

何必分成两句，等价的查询不就是

select *
  from SysBill a
 where ModelId is Null
    OR EXISTS (SELECT *
                 FROM VersionModel b
                where a.ModelId=b.ID
              )