如何把SET IDENTITY_INSERT dbo.myTable ON语句 [英] How to put SET IDENTITY_INSERT dbo.myTable ON statement
本文介绍了如何把SET IDENTITY_INSERT dbo.myTable ON语句的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我需要做的是有一个 SET IDENTITY_INSERT dbo.myTable ON
语句,什么是在C#应用程序中使用上述语句的语法?
What I need to do is have a SET IDENTITY_INSERT dbo.myTable ON
statement, what's the syntax of using the above statement in a c# app?
推荐答案
这只是相同的SQL的任何其他位:
It's just the same as any other bit of SQL:
using (var connection = new SqlConnection("Connection String here"))
{
connection.Open();
var query = "SET IDENTITY_INSERT dbo.MyTable ON; INSERT INTO dbo.MyTable (IdentityColumn) VALUES (@identityColumnValue); SET IDENTITY_INSERT dbo.MyTable OFF;";
using (var command = new SqlCommand(query, connection)
{
command.Parameters.AddWithValue("@identityColumnValue", 3);
command.ExecuteNonQuery();
}
}
这篇关于如何把SET IDENTITY_INSERT dbo.myTable ON语句的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文