SQL中的自动增量列如何在数据表中分配
本文关键字:数据表 分配 SQL | 更新日期: 2024-09-08 11:01:50
SqlBulkCopy sqlBulk = new SqlBulkCopy(conn, SqlBulkCopyOptions.KeepIdentity, t);
sqlBulk.DestinationTableName = DestTableName;
sqlBulk.BatchSize = 1000;
sqlBulk.WriteToServer(dt);
t.Commit();
如果我分配了标识列值,并且如果我不分配,则会发生错误,它会显示"主键中不允许空"列 - 该怎么办?
请阅读以下内容:
https://web.archive.org/web/20210927181836/http://www.4guysfromrolla.com/articles/102109-1.aspx
或
using (var bulkCopy = new SqlBulkCopy(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString, SqlBulkCopyOptions.KeepNulls & SqlBulkCopyOptions.KeepIdentity))
{
bulkCopy.BatchSize = (int)DetailLines;
bulkCopy.DestinationTableName = "dbo.myTable";
bulkCopy.ColumnMappings.Clear();
bulkCopy.ColumnMappings.Add("SourceColumnName", "DestinationColumnName");
bulkCopy.ColumnMappings.Add("SourceColumnName", "DestinationColumnName");
bulkCopy.WriteToServer(datatable);
}