select 1 from rpinterface_ria (nolock) where rtrim(ltrim(storecode))=@fromstore and rtrim(ltrim(DeliveryLocation))=@tostore and cast(isnull(shipmentDate,DeliveryDate) as datetime)=@shipmentdate and productcode is not null
这句话中 select 1 是什么意思
这句话中 select 1 是什么意思
if exists(select 1 from ...)或
if not exists(select 1 from ...)