Click here to Skip to main content
Rate this: bad
good
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 at 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
0 Maciej Los 230
1 OriginalGriff 202
2 Richard MacCutchan 185
3 Tomas Takac 146
4 CPallini 125
0 OriginalGriff 5,130
1 DamithSL 4,237
2 Maciej Los 3,700
3 Kornfeld Eliyahu Peter 3,470
4 Sergey Alexandrovich Kryukov 2,846


Advertise | Privacy | Mobile
Web04 | 2.8.141216.1 | Last Updated 10 Jan 2013
Copyright © CodeProject, 1999-2014
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