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:-


a third row may be:-


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).


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

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....