SQL using databse name with table name via variable

Question

I want to use a variable to fetch the select query using database name, where the database name would be stored in the variable. But i'm not able to achieve this using the below approach. Can one please let me know how to achieve this.

DECLARE @PrePublishedDB VARCHAR(100)
SET @PrePublishedDB = 'MyDatabase'

SELECT COUNT(*) FROM @PrePublishedDB.BaseVehicle

Possible duplicate of [How to use a variable for the database name in T-SQL?](https://stackoverflow.com/questions/727788/how-to-use-a-variable-for-the-database-name-in-t-sql) — Ned Howley, Aug 02 '17 at 10:16

score 1 · Answer 1 · answered Aug 02 '17 at 10:18

1

execute ('SELECT COUNT(*) FROM ' + @PrePublishedDB + '.BaseVehicle')

answered Aug 02 '17 at 10:18

SQLAndOtherStuffGuy

214
1
5

SQL using databse name with table name via variable

1 Answers1