22,209
社区成员
发帖
与我相关
我的任务
分享
--这样@item_unit是null
SELECT @item_unit=dd.Fname from MES_ITEM_DW dd where dd.FNumber=@newitem_no;
--这样是有值的
SELECT @item_unit=dd.Fname from MES_ITEM_DW dd where dd.FNumber='xxxx';
--这样还是null?
SET @newitem_no = 'xxxx'
SELECT @item_unit=dd.Fname from MES_ITEM_DW dd where dd.FNumber=@newitem_no;
SELECT * FROM MES_ITEMS JOIN MES_ITEM_DW WHERE FNumber = c_item_no
SELECT
@item_unit1 = bb.FName
FROM
t_MeasureUnit bb
WHERE
bb.FUnitGroupID = LTRIM(RTRIM(REPLACE(
REPLACE(
REPLACE(
REPLACE(REPLACE(@item_unit, ' ', ''), CHAR(9), ''),
CHAR(10), ''
), CHAR(13), ''
), CHAR(32), ''
)
)
);