如果我们的语句为：
sql;">
IF NOT EXISTS(SELECT 1 FROM sys.views WHERE name='Report_IndividualTicket')
BEGIN
create view Report_IndividualTicket
as
SELECT Ticket.TicketNumber,Ticket.TicketID,GisProcess.StageName,Content.DtReceived,Content.ContentText
FROM
(GisProcess INNER JOIN Ticket
ON GisProcess.TicketID=Ticket.TicketID)
INNER JOIN Content
ON Ticket.ContentID=Content.ContentID
END
Msg 156,Level 15,State 1,Line 4
Incorrect Syntax near the keyword 'view'.
出现这个错误的原因是：create view 这一句必须是批处理中的第一句。
所以可以将该语句修改为：
sql;">
IF EXISTS(SELECT 1 FROM sys.views WHERE name='Report_IndividualTicket')
DROP VIEW Report_IndividualTicket
GO
create view Report_IndividualTicket
as
SELECT Ticket.TicketNumber,Content.ContentText
FROM
(GisProcess INNER JOIN Ticket
ON GisProcess.TicketID=Ticket.TicketID)
INNER JOIN Content
ON Ticket.ContentID=Content.ContentID
GO
原文链接：https://www.f2er.com/mssql/63191.html