--You can try this
--CREATE A TEMPORARY TABLE
CREATE TABLE #myTemp123
(
Id INT NOT NULL IDENTITY(1,1),
AutoId AS 'ABC' + RIGHT('0000'+ CONVERT(VARCHAR(5),Id),5)
)
--INSERT DEFAULT 10000 RECORDS AT ONCE IN LOOP Simply TYPE GO 10000
INSERT INTO #myTemp123 DEFAULT VALUES;
--CHECK INSERTED RECORD
SELECT * FROM #myTemp123