Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mthoy
Starting Member
1 Post |
Posted - 2010-02-13 : 00:12:03
|
| When I execute the following mysql statement create table emp_high_pay_city_tbl as select * from emp_tblinto a mssql 2008 query window, I get the following error:Incorrect syntax near the keyword 'as'.Can someone help me identify the correct snytax? |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2010-02-13 : 00:52:39
|
| try like thisselect * into emp_high_pay_city_tbl from emp_tbl |
 |
|
|
|
|
|