datatype supplied by user for SQL field

I have a SQL table which has a number of fields

ID | Value | Type

A typical record may be :- 1000,10,[int]

a second row may be:-

1001,foo,[string]

a third row may be:-

1002,10/12/2008,[DateTime]

I have been asked to look at this as at the moment, each time we wish to select from this table we have to cast the value to the type specified. I am able to do a database redesign on this and am wondering the best route to go to optimise this. (SQL 2000).

Answers


Horrors! This is the dreaded Entity-Attribute-Value (EAV) model! Run away!

But seriously, assuming there is some reason for needing this kind of model, maybe create a properly typed column for each data type?

ID       Type      StringValue       DateValue      NumberValue
1001     String    Foo
1002     Date                        10/12/2008
1003     Number                                     123.46

Need Your Help

Rename getter/setter option by refactoring is disabled

java eclipse refactoring ibm-rad

I'm using IBM RAD 9.0. When I enter Refactoring dialog on the field name (2x alt+ctrl+R) I see the options to rename getters and setters disabled.

Kendo Grid keydown event

javascript angularjs angularjs-directive kendo-grid kendo-asp.net-mvc

I have initiated a Kendo Grid using Kendo directives. How do I catch the keydown/keypress event of the grid? My final objective is to populate a grid column based on user input of another column....

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.