查询业务伙伴户代码和名称
小于 1 分钟
示例代码
SELECT ROW_NUMBER() OVER (ORDER BY T0.[CardCode]) AS 序号, T0.[CardCode], T0.[CardName]
FROM OCRD T0
WHERE T0.[CardType] ='[%0]'
SELECT ROW_NUMBER() OVER (ORDER BY T0.[CardCode]) AS 序号, T0.[CardCode], T0.[CardName]
FROM OCRD T0
WHERE T0.[CardType] ='[%0]'