Sql Create error,Create View error,Sql error
under MSSQL8 doing this "create table tblA as ( select Name from tblB );"results in error 156 (wrong syntax near AS keyword). What is my mistake?
thanks and regardsMarkSee SELECT in Books Online:
select Nameinto dbo.tblAfrom dbo.tblB
Simon
No comments:
Post a Comment