InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 06:42:02 GMT20http://www.sqlservercentral.com/Forums/Topic1416547-3077-1.aspx[quote][b]Raymond van Laake (2/7/2013)[/b][hr]Hi,Thanks for your reply, was afraid this would be the outcome.The reason I need it is: my users can create a "campaign", and based on what's needed within that specific campaign a table is created. So at any time suddenly a new table can be present that is named dbo.Campaign00001, dbo.Campaign00002 etc.All through a user-interface, they cannot access SQL directly.[/quote]if the database is still in design phase , may be you can getaway with Entity Attribute model ; having the user create the table , I don't think that kind of stuff I would prefer.Mon, 11 Feb 2013 01:24:53 GMTdemonfoxhttp://www.sqlservercentral.com/Forums/Topic1416547-3077-1.aspxIf tables have the same structure use a partitioned view, or bind and unbind table to view, or in SQL 2012 use synonym, all depend on your needs.Thu, 07 Feb 2013 01:12:48 GMTe4d4http://www.sqlservercentral.com/Forums/Topic1416547-3077-1.aspxHi,Thanks for your reply, was afraid this would be the outcome.The reason I need it is: my users can create a "campaign", and based on what's needed within that specific campaign a table is created. So at any time suddenly a new table can be present that is named dbo.Campaign00001, dbo.Campaign00002 etc.All through a user-interface, they cannot access SQL directly.Thu, 07 Feb 2013 01:00:38 GMTRaymond van Laakehttp://www.sqlservercentral.com/Forums/Topic1416547-3077-1.aspxNope.To be honest, that's something I strongly recommend against. It's a pain, it's a security hole if you're not incredibly careful and it suggests bad design (you wouldn't write a C# class that could operate on any type of object or struct passed in, why do it in SQL?)Wed, 06 Feb 2013 09:50:29 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic1416547-3077-1.aspxHey,We're going SQL2012 in a few weeks... does this version support parameterized table names? Currently we use dynamic SQL, it would be great if that wasn't necessary anymore.For example:DECLARE @tbl VARCHAR(MAX) = 'EMPLOYEES'SELECT * FROM @tblLooked it up on google, but saw no mention this is possible in 2012, so I thought lets ask here...Thx, RaymondWed, 06 Feb 2013 08:33:40 GMTRaymond van Laake