6447Design a table for Lookup in sql server 2008
- Jun 1, 2009Hi Team,
I am facing some problems on designing the look up table.
We are going to move data by using lookup table and for that I have designed few columns based on the data like this..
ID,tablename,S_char, S_int, T_int, T_char, T_bit
When I insert my data to corresponding fields with 4K rows, rest of the columns are having NULL values. Is there any issue with performance wise or any other
Instead of that can I go with 2 columns one is source and 2nd one is target value with "nvarchar" data types.
Which approach is good and how best I can go with that. Is it required any check constraint for the 2nd approach?
Please help me in that and one more we don't have any relationship with this table, it's an independent table.
Thanks in advance.
- Next post in topic >>