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 regards
MarkSee SELECT in Books Online:
select Name
into dbo.tblA
from dbo.tblB
Simon
Sql Create error,Create View error,Sql error
No comments:
Post a Comment