asked
Get the Actual object (such as a table) in SQL Server?
I want to get the actual object - not the information about it in sys.objects. It would be really great if I could get a table based on its ID, assign it to a table variable, and then use that in a query instead of having to use dynamic sql. Why, you ask? The silly database I am working with has tables with names ending in a four digit year. I want to be able to pass a parameter to get the table to query. I searched high and low for this capability so maybe it's not possible but hoping it is... Any other suggestions would be greatly appreciated.
If the only difference between the tables is the year in its name, you could use Partitioned Views ([
http://technet.microsoft.com/en-us/library/ms190019(v=sql.105).aspx][1]) or, a bit more involved, combine the tables into a single partitioned table ([
http://technet.microsoft.com/en-us/library/ms190787.aspx][2]). With a partitioned view or table you won't have to know a special table name, you just filter the results by the year you are looking for. Outside of that, you may be stuck with the dynamic SQL approach. [1]:
http://technet.microsoft.com/en-us/library/ms190019(v=sql.105).aspx [2]:
http://technet.microsoft.com/en-us/library/ms190787.aspx
"I know the name but it's a string - not the actual table" So, you didn't actually look into partitioned views or the dynamic SQL approach?
16 People are following this question.
