SQL SERVER先判断视图是否存在然后再创建视图的语句
16lz
2022-01-09
如果我们的语句为:
IF NOT EXISTS(SELECT 1 FROM sys.views WHERE name='Report_IndividualTicket')BEGINcreate view Report_IndividualTicketasSELECT Ticket.TicketNumber, Ticket.TicketID,GisProcess.StageName,Content.DtReceived, Content.ContentTextFROM(GisProcess INNER JOIN TicketON GisProcess.TicketID=Ticket.TicketID)INNER JOIN ContentON Ticket.ContentID=Content.ContentIDEND
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_IndividualTicketGOcreate view Report_IndividualTicketasSELECT Ticket.TicketNumber, Ticket.TicketID,GisProcess.StageName,Content.DtReceived, Content.ContentTextFROM(GisProcess INNER JOIN TicketON GisProcess.TicketID=Ticket.TicketID)INNER JOIN ContentON Ticket.ContentID=Content.ContentIDGO
更多相关文章
- 如何去掉状态栏和内容视图之间的黑色阴影线
- android中文api(89)——ViewManager
- Android中的FILL_PARENT与WRAP_CONTENT的区别
- android用户界面-组件Widget-地图视图MapView
- Android(安卓)中文API(86)——ResourceCursorAdapter
- android用户界面-组件Widget-画廊视图Gallery
- android 中文api (62) —— ViewSwitcher.ViewFactory
- Android中滑屏初探 ---- scrollTo 以及 scrollBy方法使用说明
- android api 中文 (74)—— AdapterView.AdapterContextMenuInfo