if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ps]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[ps]
GO
CREATE VIEW dbo.ps
AS
SELECT * FROM pssdelphi书写如下
SQL.ADD('
if exists (select * from dbo.sysobjects where id = object_id(N''[dbo].[ps]'') and OBJECTPROPERTY(id, N''IsProcedure'') = 1)
drop procedure [dbo].[ps] #13#10
GO #13#10
CREATE VIEW dbo.ps
AS
SELECT * FROM pss')
ExecSQL;
drop procedure [dbo].[ps]
GO
CREATE VIEW dbo.ps
AS
SELECT * FROM pssdelphi书写如下
SQL.ADD('
if exists (select * from dbo.sysobjects where id = object_id(N''[dbo].[ps]'') and OBJECTPROPERTY(id, N''IsProcedure'') = 1)
drop procedure [dbo].[ps] #13#10
GO #13#10
CREATE VIEW dbo.ps
AS
SELECT * FROM pss')
ExecSQL;
ADO执行多条SQL用分号分隔