Incorrect syntax near the keyword 'as'.

• sql_time

  SSC-Addicted

  Points: 479

  More actions

  October 25, 2009 at 6:01 pm

  #73397

  I know its simple but I am not able to understand this error I got this error when I tried creating an exesting table which has huge data.

  To make is easy i tried using sample table

  I created a sample table

  create table temp1 (

  ser_no integer );

  when I tried creating another table using below statement

  create table temp2 as (select * from temp1 );

  I am getting below error

  "Msg 156, Level 15, State 1, Line 1

  Incorrect syntax near the keyword 'as'"

  Do you think any grant issues.

• Sergiy

  SSC Guru

  Points: 110209

  More actions

  October 25, 2009 at 7:25 pm

  #1070477

  No, it's incorrect sysntax issue.

  Correct statement would look like this:

  select *

  into temp2

  from temp1

  _____________
  Code for TallyGenerator

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738773

  More actions

  October 25, 2009 at 9:10 pm

  #1070498

  Please don't cross post. I am closing this thread.