How do i find out in sql what db name I'm connected to

Question

We have a change control environment where the developers give scripts to change control people to run. we have dev,qa, & production environments.

I want to conditionalize a couple segments to do some different things depending on what database the change control person is running my script.

If @dbname='dev'
then
begin
 --do some dev stuff
end
If @dbname='QA'
then
begin
 --do some qa stuff
end
If @dbname='Prod'
then
begin
 --do some production stuff
end

How do I get at what the current connected database is and fill @dbname?

Answer 1

SELECT db_name() should do the trick.

Answer 2

Use the system function db_name()

Select db_Name()

Answer 3

I think it's just like:

SELECT DB_NAME() AS DBName