hi all,
how do i return a count(*) with a dynamic database name into a variable.

for eg.
declare @cnt int

select @cnt='select count(*) from ['+@dbname'+].dbo.titles'
here select statement is stored into the variable
when executed I do get the number but i need to store that number

Thanks
Sneha