من کد اسکیوال را می خواهم در یک ado query در دلفی اجرا کنم اما بعضی از دستورات رو نمی شناسه مثل دستور "Go" و کامنت ها
نمونه کد:
/*
2012/11/0905:47:38 ب.ظ
User: sa
Server: nic\sql2008
Database: PmNicDbYazd
Application:
*/
/* To prevent any potential data loss issues, you should review this script in detail before running it outside the context of the database designer.*/
BEGIN TRANSACTION
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_NULLS ON
SET ANSI_PADDING ON
SET ANSI_WARNINGS ON
COMMIT
BEGIN TRANSACTION
GO
CREATE TABLE dbo.Tmp_aaa
(
srl int NOT NULL,
a int NOT NULL,
b int NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE dbo.Tmp_aaa SET (LOCK_ESCALATION = TABLE)
GO
IF EXISTS(SELECT * FROM dbo.aaa)
EXEC('INSERT INTO dbo.Tmp_aaa (srl, a, b)
SELECT srl, a, b FROM dbo.aaa WITH (HOLDLOCK TABLOCKX)')
GO
DROP TABLE dbo.aaa
GO
EXECUTE sp_rename N'dbo.Tmp_aaa', N'aaa', 'OBJECT'
GO
ALTER TABLE dbo.aaa ADD CONSTRAINT
PK_aaa PRIMARY KEY CLUSTERED
(
srl
) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
COMMIT