SQL Server 中创建视图报错:错误信息提示“错误的语法:'CREATE VIEW'必须是批处理中仅有的语句。,程序员大本营,技术文章内容聚合第一站。
错误的语法：createview必须是批处理中仅有的语句 编写脚本提⽰：错误的语法:"create view必须是批处理中仅有的语句"IF NOT EXISTS ( SELECT1 FROM sys.views WHERE name ='v_CS_UserRoleNames' )BEGIN CREATE VIEW v_CS_UserRoleNames AS SELECT c.UserID AS ur_UserID ,c.LoginID AS ur_Log...
错误的语法:"create view必须是批处理中仅有的语句" IFNOTEXISTS(SELECT1FROMsys.viewsWHEREname='v_CS_UserRoleNames')BEGINCREATEVIEWv_CS_UserRoleNamesASSELECTc.UserIDASur_UserID , c.LoginIDASur_LoginID , c.FullNameASur_FullName , c.[Status]ASur_Status , c.ZoneIDASur_ZoneID , c.OrgIDA...