填充0以返回查询并插入到临时表中

SELECt OrderID,
‘Z’+RIGHt(‘0000000’+CAST(OrderID AS VARCHAr(7)),7)
FROM db1.zm.dbo.zOrder
WHERe AccountID = 631180

在问题编辑后更新

DECLARE @OrderNumTable table (orderNum  varchar(8))INSERT INTO @OrderNumTable(orderNum)SELECt 'Z'+RIGHt('0000000'+CAST(OrderID AS VARCHAr(7)),7)FROM db1.zm.dbo.zOrder WHERe AccountID = 631180