I have a SQL Statement here for which I keep getting the following error message:
SQL Server Database Error: Incorrect syntax near 'Contacts_full'.
This is the SQL Statement:
Create Table Contact_info AS (Select * from Contacts_full);
I have issued similar statements in Oracle but for some reason it gives me an Error in SQL Server 2005.