John Mason | SQLServerCentral

John Mason

Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

RE: How to select from database passed as param without dynamic sql?

Hi,

I dont think I can do:

SELECT * FROM [@mydatabasename].[dbo].[Products]

Can I?

Ive been doing:

SELECT @SQL = 'SELECT * FROM ['+@mydatabasename+'].[dbo].[Products]'

?

January 27, 2005 at 6:05 pm

#539463
RE: Finding gaps in ranges...how?

thanks very much guys, it worked famously!

Regards

January 23, 2005 at 11:33 am

#538663

Viewing 2 posts - 1 through 2 (of 2 total)