<< Getting the SQL server instance name using T-SQL | Finding currently logged in user with T-SQL >>

Using T-SQL to get database name

by Joe Hunter 18. February 2010 17:50

If you need to get the database name in T-SQL sproc:

select db_name()

Tags: t-sql

Related posts

T-SQL function to return name of log file for a database ALTER FUNCTION [dbo].[UDF_DB_LOG_FILE_NAME] ( &...Getting the SQL server instance name using T-SQLHandy @@ function for getting the SQL server instance name using T-SQL: SELECT @@servernameHow can you get current stored procedure name via T-SQL? SELECT OBJECT_NAME(@@PROCID)

Powered by BlogEngine.NET 1.5.0.7
Theme by Mads Kristensen