删除视图和创建试图时,需要query batch声明吗?怎么声明?IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[VD]') AND type in (N'V'))
DROP VIEW VD CREATE VIEW VD (DID,AID,DCode,DName) AS
SELECT 。。
删除和创建分开执行都能成功
但是,一起执行时,出现错误,需要query batch的声明
DROP VIEW VD CREATE VIEW VD (DID,AID,DCode,DName) AS
SELECT 。。
删除和创建分开执行都能成功
但是,一起执行时,出现错误,需要query batch的声明
DROP VIEW VD
goCREATE VIEW VD (DID,AID,DCode,DName) AS
SELECT ...
go
加个go.
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[VD]') AND type in (N'V'))
DROP VIEW VD
goCREATE VIEW VD (DID,AID,DCode,DName) AS
SELECT 。。