SELECT * FROM [WP_CashCenter_StockContainer] WHERE [PreannouncementType] = 0 AND ([Number] = @number OR [SecondNumber] = @number OR [PermanentNumber] = @number) AND ( [Type] IN (1,2) OR [Type] IS NULL ) unknown (@number nvarchar(18),@secondNumber nvarchar(4000),@permanentNumber nvarchar(4000))SELECT * FROM [WP_CashCenter_StockContainer] WHERE [PreannouncementType] = 0 AND ([Number] = @number OR [SecondNumber] = @number OR [PermanentNumber] = @number) AND ( [Type] IN (1,2) OR [Type] IS NULL ) SELECT * FROM [WP_CashCenter_StockContainer] WHERE [PreannouncementType] = 0 AND ([Number] = @number OR [SecondNumber] = @number OR [PermanentNumber] = @number) AND ( [Type] IN (1,2) OR [Type] IS NULL ) unknown (@number nvarchar(18),@secondNumber nvarchar(4000),@permanentNumber nvarchar(4000))SELECT * FROM [WP_CashCenter_StockContainer] WHERE [PreannouncementType] = 0 AND ([Number] = @number OR [SecondNumber] = @number OR [PermanentNumber] = @number) AND ( [Type] IN (1,2) OR [Type] IS NULL ) UPDATE [WP_CashCenter_StockContainer] SET [number] = @number, [type] = @type, [preannouncementtype] = @preannouncementtype, [servicedate] = @servicedate, [status] = @status, [totalquantity] = @totalquantity, [totalvalue] = @totalvalue, [totalweight] = @totalweight, [datecreated] = @datecreated, [dateupdated] = @dateupdated, [stockorder_id] = @stockorder_id, [parentcontainer_id] = @parentcontainer_id, [locationfrom_id] = @locationfrom_id, [locationto_id] = @locationto_id, [isexpected] = @isexpected, [isopen] = @isopen, [ismissing] = @ismissing, [ismisscan] = @ismisscan, [datecollected] = @datecollected, [ismultienvelope] = @ismultienvelope, [uid] = @uid, [isprecrediting] = @isprecrediting, [isfordispatching] = @isfordispatching, [isdetonated] = @isdetonated, [isonhold] = @isonhold, [iscancelled] = @iscancelled, [editor_id] = @editor_id WHERE [id] = @id unknown (@number nvarchar(18),@type int,@preannouncementtype int,@servicedate datetime,@status int,@totalquantity int,@totalvalue decimal(2,2),@totalweight decimal(5,5),@datecreated datetime,@dateupdated datetime,@stockorder_id bigint,@parentcontainer_id bigint,@locationfrom_id decimal(10,0),@locationto_id decimal(10,0),@isexpected bit,@isopen bit,@ismissing bit,@ismisscan bit,@datecollected datetime,@ismultienvelope bit,@uid uniqueidentifier,@isprecrediting bit,@isfordispatching bit,@isdetonated bit,@isonhold bit,@iscancelled bit,@editor_id nvarchar(4000),@id bigint)UPDATE [WP_CashCenter_StockContainer] SET [number] = @number, [type] = @type, [preannouncementtype] = @preannouncementtype, [servicedate] = @servicedate, [status] = @status, [totalquantity] = @totalquantity, [totalvalue] = @totalvalue, [totalweight] = @totalweight, [datecreated] = @datecreated, [dateupdated] = @dateupdated, [stockorder_id] = @stockorder_id, [parentcontainer_id] = @parentcontainer_id, [locationfrom_id] = @locationfrom_id, [locationto_id]