34,590
社区成员
发帖
与我相关
我的任务
分享
DBCC DBREINDEX ( 'PrintRecord','PK_PrintRecord')
DBCC DBREINDEX ( 'PrintRecord','IX_PrintRecord')
ALTER PROCEDURE [dbo].[P_InsertPrint]
@dataNumber INT, -- 需要插入的数据量
@barcode_sku nvarchar(50),
@printerName nvarchar(200),
@print_count_number int,
@print_ModelChild_Id int,
@print_user int
AS
if(@barcode_sku = '' or @barcode_sku is null)
select 1
else
begin
INSERT INTO PrintRecord(barcode_sku,PrinterName,print_count_number,print_ModelChild_Id,print_user,fid,barcode_code)
SELECT TOP(@dataNumber)
@barcode_sku,
@printerName,
@print_count_number,
@print_ModelChild_Id,
@print_user,
CAST((case when (select max(fid) from PrintRecord where barcode_sku = @barcode_sku) is not null then ((select max(fid) from PrintRecord where barcode_sku = @barcode_sku)+( ROW_NUMBER() OVER(ORDER BY o.object_id))) else ( ROW_NUMBER() OVER(ORDER BY o.object_id)) end) AS nvarchar(20)),
@barcode_sku+'_'+RIGHT('000000'+CAST((case when (select max(fid) from PrintRecord where barcode_sku = @barcode_sku) is not null then ((select max(fid) from PrintRecord where barcode_sku = @barcode_sku)+( ROW_NUMBER() OVER(ORDER BY o.object_id))) else ( ROW_NUMBER() OVER(ORDER BY o.object_id)) end) AS nvarchar(20)),7)
FROM sys.all_objects AS o,sys.all_columns AS c
select 0
end