mssql 真的非常差!

开三个线程跑下面的这个 Do() 函数就会发生死锁.
开三个线程以上,就根本跑不起来!.
不就是对同一主从表进行增删改操作么.就1000条也会这样,太差了!

C# code:

public void Do()
{
System.Text.StringBuilder sb = new StringBuilder();

sb.Append(@"
declare @branchid as varchar(50)
declare @maccolr as varchar(50)
declare @pkey as uniqueidentifier
declare @userid as varchar(50)
declare @styleid as varchar(50)
declare @colorid as varchar(50)
declare @sizeid as varchar(50)
declare @qty as int

set @branchid = 'y7500" + ID.ToString() + @"'
set @maccolr = '" + ID.ToString() + @"'
set @pkey = newid()
set @userid ='userid" + ID.ToString() + @"'

set @qty =10*" + ID.ToString() + @"

delete from pdaorderd
where pkey in
(
select pkey from pdaorder where branchid=@branchid and maccolr=@maccolr
)

delete from pdaorder where branchid=@branchid and maccolr=@maccolr

INSERT INTO [pdaorder]([pkey], [branchid], [userid], [maccolr])
select @pkey,@branchid,@userid,@maccolr

");

for(int i=0;i<1000;i++)
{
sb.Append(@"
INSERT INTO [pdaorderd]([pkey], [styleid], [colorid], [sizeid], [qty])
select @pkey,'style"+i.ToString()+"','color"+i.ToString()+"','size"+i.ToString()+