Tuesday, June 4, 2019

MS SQL Server - Select - Database Name

---------------------
SELECT DB_NAME() AS [Current Database];
---------------------------

USE master;
GO
SELECT DB_NAME(3)AS [Database Name];
GO


------------


SELECT DB_NAME(database_id) AS [Database], database_id
FROM sys.databases;  

No comments:

Post a Comment

Recently Executed queries

 SELECT     txt.TEXT AS [SQL Statement],     qs.EXECUTION_COUNT [No. Times Executed],     qs.LAST_EXECUTION_TIME AS [Last Time Executed],   ...