1 --循环得出 数据库中所有的 DB_ID,DB_NAME 2 CREATE TABLE #T 3 ( 4 "DB_NAME()" int, 5 "DB_ID" int, 6 "DB_NAME" nvarchar(100) 7 ) 8 9 declare @n int=0 10 while(DB_NAME(@n)!='NULL') 11 BEGIN 12 insert #T values(@n,DB_ID(DB_NAME(@n)),DB_NAME(@n)) 13 set @n=@n+1 14 END 15 16 SELECT * FROM #T 17 18 DROP TABLE #T 19 20 21 --遍历 数据库中所有 DB_ID DB_NAME 22 declare @a int=0 23 while(DB_NAME(@n)!='NULL') 24 BEGIN 25 select @a as 'DB_NAME()',DB_NAME(@a) AS 'DBNAME()' 26 SET @a=@a+1 27 END 28 29 30 --判断是否为空 31 declare @a int=0 32 if(DB_NAME(6)!='NULL') 33 print CAST(1 AS NVARCHAR)+CHAR(9)+DB_NAME(6) 34 else 35 print 2 36 37 declare @a int=0 38 if(DB_NAME(6)!='NULL') 39 begin 40 print CAST(1 AS NVARCHAR)+'制表符'+CHAR(9)+DB_NAME(6) 41 print CAST(1 AS NVARCHAR)+'换行'+CHAR(10)+DB_NAME(6) 42 print CAST(1 AS NVARCHAR)+'回车'+CHAR(13)+DB_NAME(6) 43 end 44 else 45 print 2