22,300
社区成员




DECLARE @t TABLE (
xid INT IDENTITY(1,1) PRIMARY KEY,
xData NVARCHAR(20)
)
INSERT INTO @t (xData)VALUES ('aaa')
INSERT INTO @t (xData)VALUES ('bbb')
INSERT INTO @t (xData)VALUES ('ccc')
SELECT
'MD'+RIGHT('00000000'+LTRIM(xid),8) AS xid
,xData
FROM @t
/*
xid xData
------------------ --------------------
MD00000001 aaa
MD00000002 bbb
MD00000003 ccc
*/