插入多行数据时对表的锁定

表结构如下：

CREATE TABLE Sync_Bas_Customer( [fSyncID] [int] IDENTITY (1, 1) NOT NULL , [fChangeType] [smallint] NOT NULL , [fOrgID] [int] NOT NULL , [fSyncLogID] [uniqueidentifier] NULL , [fSync_fCustID] [int] NOT NULL ) ON [PRIMARY]

//测试代码

int i = 0;while (i++ < 10){    SqlHelper.ExecuteNonQuery(trans, CommandType.Text,        "Insert into Sync_Bas_Customer with(tablock)(fChangeType,fOrgID,fSync_fCustID)" +        "Values(0,1,"+this.textBox1.Text+")");    System.Threading.Thread.Sleep(500);}

//测试结论

如果不使用with(tablock)则并发执行时将不会按顺序生成数据