SQL-server: Get current database name
It can sometimes be handy to know in which database you are working. To get the name of the current database you can use a simple script:
SELECT DB_NAME() AS DataBaseName
Resultset:
DatabaseName
------------------------
NorthWind
(1 row(s) affected)
------------------------
NorthWind
(1 row(s) affected)
I am a .NET programmer first and foremost. But in my spare time I like to play around with PHP, Erlang, Haskell, F#,