sql server批量添加问题，一次执行单条或者10条都没问题，但执行50条就报错。
0
悬赏园豆：10
[已关闭问题]
关闭于 2017-06-15 18:01
表结构如下
插入数据sql如下，由于字数限制，就只贴两条，其他都一样：
INSERT [tDrug] ([Id],[fGSPCompanyId],[fLicenseNumber],[fName],[fNameEn],[fCommodityName],[fFormat],[fDrugType],[fFactory],[fCreativeAddr],[fProductType],[fLicenseDate],[fOriginLicenseNumber],[fDrugStandardCode],[fNetPrice],[fBidPrice],[fState],[fDate],[fBz]) SELECT N'234175f5-6ac8-4a9d-b67b-b0cfe83698e7' AS Id,N'd59b9ead-7c5f-4d51-937c-058c7c6b96aa' AS fGSPCompanyId,N'国药准字S20053035' AS fLicenseNumber,N'注射用重组人生长激素' AS fName,N'Recombinant Human Growth Hormone For Injection' AS fNameEn,N'海之元' AS fCommodityName,N'2.5IU' AS fFormat,N'注射剂' AS fDrugType,N'中山海济医药生物工程股份有限公司' AS fFactory,N'中山火炬开发区生物谷大道16号' AS fCreativeAddr,N'生物制品' AS fProductType,'2017-05-09 12:00:00.00' AS fLicenseDate,N'' AS fOriginLicenseNumber,N'86900578000023' AS fDrugStandardCode,N'0' AS fNetPrice,N'0' AS fBidPrice,N'1' AS fState,'2017-06-15 05:25:00.250' AS fDate,N'' AS fBz UNION ALL SELECT N'12d07428-d55a-4541-b2c4-4a935647ff10' AS Id,N'd59b9ead-7c5f-4d51-937c-058c7c6b96aa' AS fGSPCompanyId,N'国药准字S20053034' AS fLicenseNumber,N'注射用重组人生长激素' AS fName,N'Recombinant Human Growth Hormone For Injection' AS fNameEn,N'海之元' AS fCommodityName,N'8IU' AS fFormat,N'注射剂' AS fDrugType,N'中山海济医药生物工程股份有限公司' AS fFactory,N'中山火炬开发区生物谷大道16号' AS fCreativeAddr,N'生物制品' AS fProductType,'2017-05-09 12:00:00.00' AS fLicenseDate,N'' AS fOriginLicenseNumber,N'86900578000016' AS fDrugStandardCode,N'0' AS fNetPrice,N'0' AS fBidPrice,N'1' AS fState,'2017-06-15 05:25:03.253' AS fDate,N'' AS fBz UNION ALL SELECT N'5a4d24dc-9caf-4fe5-82bc-5a4db506eb06' AS Id,N'd59b9ead-7c5f-4d51-937c-058c7c6b96aa' AS fGSPCompanyId,N'国药准字S20053036' AS fLicenseNumber,N'注射用重组人生长激素' AS fName,N'Recombinant Human Growth Hormone For Injection' AS fNameEn,N'海之元' AS fCommodityName,N'4IU' AS fFormat,N'注射剂' AS fDrugType,N'中山海济医药生物工程股份有限公司' AS fFactory,N'中山火炬开发区生物谷大道16号' AS fCreativeAddr,N'生物制品' AS fProductType,'2017-05-09 12:00:00.00' AS fLicenseDate,N'' AS fOriginLicenseNumber,N'86900578000030' AS fDrugStandardCode,N'0' AS fNetPrice,N'0' AS fBidPrice,N'1' AS fState,'2017-06-15 05:25:03.253' AS fDate,N'' AS fBz
