关于动态创建视图的问题,请大家帮忙?
我想在程序中编写代码创建一视图,代码是:
CREATE VIEW dbo.RecordView
AS
SELECT dbo.Record.UserID, dbo.UserInfo.UserName, dbo.UserInfo.Office,
dbo.UserInfo.ExtName, dbo.Record.OutLine, dbo.Record.[Public],
dbo.Record.WkgName, dbo.Record.Direct, dbo.Record.StartTime,
dbo.Record.EndTime, dbo.Record.[Second], dbo.Record.FileName
FROM dbo.UserInfo INNER JOIN
dbo.Record ON dbo.UserInfo.UserID = dbo.Record.UserID
其中UserInfo表和Record表已存在,但是程序出错,提示说:CREATE VIEW 必须是查询中的第一条语句,请大家帮我分析一下错误的原因,谢谢!