为什么ADOCommand控件执行下面的代码会出错?
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DataProcess]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[DataProcess]
GOSET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GOCREATE PROCEDURE DataProcess
(
@OldName nvarchar(50),
@NewName nvarchar(50)
)
as if @OldName is null return 0
if @NewName is null return 0 exec('delete from '+@NewName+'.dbo.FIELDSTYLE')
exec('insert into '+@NewName+'.dbo.FIELDSTYLE'+
' select * from '+@OldName+'.dbo.FIELDSTYLE') exec('delete from '+@NewName+'.dbo.QUERYCONDITION')
exec('insert into '+@NewName+'.dbo.QUERYCONDITION'+
' select * from '+@OldName+'.dbo.QUERYCONDITION')
return 1
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[DataProcess]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[DataProcess]
GOSET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GOCREATE PROCEDURE DataProcess
(
@OldName nvarchar(50),
@NewName nvarchar(50)
)
as if @OldName is null return 0
if @NewName is null return 0 exec('delete from '+@NewName+'.dbo.FIELDSTYLE')
exec('insert into '+@NewName+'.dbo.FIELDSTYLE'+
' select * from '+@OldName+'.dbo.FIELDSTYLE') exec('delete from '+@NewName+'.dbo.QUERYCONDITION')
exec('insert into '+@NewName+'.dbo.QUERYCONDITION'+
' select * from '+@OldName+'.dbo.QUERYCONDITION')
return 1
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
比如,
引号不配对等因素。