我正在尝试创建一个唯一的密钥,格式如下:例如,它从ABC开始,到ABC999999结束,基本上前三个字符是ABC,然后是6个数字。 SELECT
'ABC' + CAST(REPLICATE('0',6-LEN(RTRIM(ROW_NUMBER() OVER (ORDER BY (SELECT NULL))))+ (SELECT Counter from Counters)) + RTRIM(ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) + (SELECT Count