Click here to Skip to main content
12,075,610 members (65,986 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: SQL Server
the following query give an error nearer to as.this query use for creating the same structure as another

Create table emp1 as select * from emp where 1=2;


Error:Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'as'.
Posted 10-Jan-13 4:51am
Edited 10-Jan-13 4:59am
v3
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

Try the below

Select * Into emp1 
from emp where 1=2;


Refer the below link it will help you

http://www.w3schools.com/sql/sql_select_into.asp[^]
  Permalink  
v2
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 2

SELECT column_name(s)
    INTO dbo.emp1
FROM dbo.emp WITH(NOLOCK) 
WHERE 1=1

try this I guess this is what you looking for.
  Permalink  
Comments
djj55 10-Jan-13 13:36pm
   
I think they were trying for the structure not the data thus 1=2
Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 3

CREATE TABLE TABLE2
AS
SELECT * FROM TABLE1 WHERE 1=2
This is a shortcut for copying a table structure in Oracle! Why you use it in SQL i can't understand!..To use this in SQL you need to use as above 2 solutions stated.
  Permalink  
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web01 | 2.8.160208.1 | Last Updated 10 Jan 2013
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100