'CREATE VIEW' 必须是查询批次中的第一个语句。
在c#中创建视图,出现'CREATE VIEW' 必须是查询批次中的第一个语句。 怎么解决啊
语句为
sql = string.Format(@"user {0} CREATE VIEW [dbo].vHisData AS {1} ", filename, viewSql); 其中filename为数据库名,viewsql为 连接表的语句
sql = string.Format(@"user {0} go CREATE VIEW [dbo].vHisData AS {1} ", filename, viewSql);
sql = string.Format(@"user {0}
go
CREATE VIEW [dbo].vHisData AS {1} ", filename, viewSql);
sql = string.Format(@"user {0};
go
CREATE VIEW [dbo].vHisData AS {1} ", filename, viewSql);
等都报这个错误