Re: Re-design of data storage table
From: Erland Sommarskog <esquel_at_sommarskog.se>
Date: Mon, 2 Mar 2009 13:38:59 +0000 (UTC)
Message-ID: <Xns9BC2989AD7BCFYazorman_at_127.0.0.1>
__Paul (paulwragg2323_at_hotmail.com) writes:
> Up to now the advice has been run like hell, don't do it, ha ha you
> noob etc. Advice on an alternative approach would be more
> constructive. Or is the only alternative to have a table with as many
> columns as possible to support this?
Date: Mon, 2 Mar 2009 13:38:59 +0000 (UTC)
Message-ID: <Xns9BC2989AD7BCFYazorman_at_127.0.0.1>
__Paul (paulwragg2323_at_hotmail.com) writes:
> Up to now the advice has been run like hell, don't do it, ha ha you
> noob etc. Advice on an alternative approach would be more
> constructive. Or is the only alternative to have a table with as many
> columns as possible to support this?
The third alternative would be to have a mechanism where by the users can alter the tables and columns through the application, so that the application can track these columns and be able to use them. Needless to say, this also takes some effort to implement. Security becomes an issue, and while SQL 2005 offers solutions to deal with this, that is nothing that is portable to Oracle (which is likely to offer solutions). Upgrades to the applicaiton becomes problematic, because you will not know what is out there.
-- Erland Sommarskog, SQL Server MVP, esquel_at_sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspxReceived on Mon Mar 02 2009 - 07:38:59 CST