一条sql语句循环插入N条不同记录(转)

SET NOCOUNT ON    
    
IF (OBJECT_ID(‘TB‘ ) IS NOT NULL ) DROP TABLE TB    
GO     
    
CREATE TABLE TB(ID INT IDENTITY (1,1),NAME VARCHAR(40))    
GO     
    
INSERT INTO TB(NAME) SELECT ‘KK‘+CONVERT(VARCHAR(5),isnull(@@IDENTITY,0)+1)    
GO 10   --GO 后面为执行的次数    
    
SET NOCOUNT OFF    
    
SELECT * FROM TB