笔记255 SQLSERVER使用SELECT * INTO 复制数据或者只复制结构 2013-4-29

笔记255 SQLSERVER使用SELECT * INTO 复制数据或者只复制结构 2013-4-29

--SQLSERVER使用SELECT * INTO 复制数据或者只复制结构 2013-4-29
USE [tempdb]
GO
CREATE TABLE #AreaA
    (
      AreaID INT NOT NULL ,
      ParentID NVARCHAR(100) ,
      Area_index NVARCHAR(100)
    )
GO
INSERT INTO [#AreaA]
        ( [AreaID] ,
          [ParentID] ,
          [Area_index]
        )
SELECT 100,NULL,N'中国' UNION ALL
SELECT 101,'北京市 100',',100,' UNION ALL
SELECT 102,'海淀区 101','100,101,'

SELECT * FROM [#AreaA]

SELECT * FROM [#AreaA] where AreaID = 101 OR [Area_index] like '%,101,%'

SELECT * INTO #keep FROM [#AreaA] WHERE 1 = 2 --WHERE 条件为假，所以只能复制结构
SELECT * INTO #AreaB FROM [#AreaA] WHERE 1 = 1  --WHERE条件为真，所以复制数据和结构

SELECT * FROM [#keep]
SELECT * FROM [#AreaB]