如果我們的語句為：
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 這一句必須是批處理中的第一句。
所以可以將該語句修改為：
IF EXISTS(SELECT 1 FROM sys.views WHERE name='Report_IndividualTicket')
DROP VIEW Report_IndividualTicket
GO
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
GO
您可能感興趣的文章:- Mysql判斷表字段或索引是否存在
- sql server中判斷表或臨時表是否存在的方法
- mysql判斷字段是否存在的方法
- SQL判斷字段列是否存在的方法
- mysql中判斷記錄是否存在方法比較
- mySQL count多個表的數據實例詳解
- sql中count或sum為條件的查詢示例(sql查詢count)
- SQL判斷是否"存在",還在用 count 操作?很耗時的！
