CBTr.Net Tech Dump

I just saw this new function being utilized in one of our script: quotename. It is fairly simply to use. Now you don’t have to write anything like the following:

declare @database_name varchar(50)
set @database_name = db_name()
set @database_name = '[' + @database_name + ']' + ';'
select 'use ' + @database_name

or

declare @database_name varchar(50)
set @database_name = '[' + db_name() + ']' + ';'
--set @database_name = '[' + @database_name + ']' + ';'
select 'use ' + @database_name

The fn quotename will take care of it for you .