绑定存储过程

ALTER PROCEDURE [dbo].[checkAssemblyProductExists]
        @productId nvarchar(50),
        @lotId nvarchar(50),
        @stationId nvarchar(50),
        @routeStepId nvarchar(50),
        @userId nvarchar(50),
        @masterBoxNo nvarchar(50),
        @boxNo nvarchar(50)
AS
BEGIN
    --判断条码，产品唯一
    declare @serialNumber nvarchar(100)
    select @serialNumber=serial_Number from QS_ASSEMBLY where product_id = @productId and assembly_sn = @boxNo

    --未查询到同产品绑定记录，返回成功
    if @serialNumber is null or @serialNumber = ''
    begin
        select 0 errorcode
        return;
    end else
    begin
        select 1 errorcode,'条码' + @boxNo + '已绑定其他主条码'+@serialNumber msg
    end


END