Question

我使用 SQLDataAdapter 运行脚本。脚本如下:

ALTER TABLE dbo.Table1 SET (LOCK_ESCALATION = TABLE)
GO
COMMIT
select Has_Perms_By_Name(N dbo.Table1 ,  Object ,  ALTER ) as ALT_Per, Has_Perms_By_Name(N dbo.Table1 ,  Object ,  VIEW DEFINITION ) as View_def_Per, Has_Perms_By_Name(N dbo.Table1 ,  Object ,  CONTROL ) as Contr_Per BEGIN TRANSACTION
GO
ALTER TABLE dbo.Table2
DROP CONSTRAINT DF_Table2
GO

它在 Go 附近的不正确的语法给我错误。如果我从查询文本中删除 Go, 它就会正常工作。但我只需要执行此脚本。

这里是 c# 代码。查询文本是一个字符串, 包含全部查询以及 SET 和 GO 。

DataSet ds = new DataSet();
SqlConnection conn = new SqlConnection(_connectionString);
SqlDataAdapter da = new SqlDataAdapter(QueryText, conn);
da.Fill(ds);

有谁知道怎么用它吗?

Thanks in advance,
Vijay

Answer 1

GO is a marker for Management Studio or other SQLServer command lines tools and serve as final delimiter to send a batch of commands to SQL Server.
In your code, you need to replicate this behavior.
Separate the script in subparts using the GO as delimiter.
Send each part using a single command (for the ALTER TABLE) and use your SqlDataAdapter for the SELECT part.
Also you should remove the COMMIT and BEGIN TRANSACTION from the script parts and use, inside your code, the SqlTransaction object from the SqlConnection.

友情链接