sql server - Parameters in "use [database]" clause -

i want use parameters in use [database] command, runs without changing database under usage.

how can fix it? lot

declare @database varchar(100) set @database = 'transform'  declare @sqlstring nvarchar(500) set @sqlstring = 'use '+ @database  exec sp_executesql @sqlstring 

it changes database, within context of sp_executesql

try confirm:

set @sqlstring = 'use '+ @database + ';  select db_name()'