Sunday, July 27, 2014

passing database name as sql parameter

Hi,


Is it possible to pass the database name as a parameter ? Thinking if I could do a "using @dbparamname"


I have a stored procedure that needs to get data from different databases based on what part of the application is called. The database schema is exactly same but only data is different.


Is there any other way of doing this ?


No comments:

Post a Comment