Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jason100
Starting Member
34 Posts |
 Posted - 2009-02-08 : 22:43:38
|
| I'm provideing a requirement.This requirement need to store the tracking data. But there are two variable columns. and those variable columns just store nvarchar(1000) sometime. So I want to design two tables. One for the long column other for the short. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-08 : 23:18:56
|
| Your explanation is not clear. Can you Elaborate? |
 |
|
|
Jason100
Starting Member
34 Posts |
Posted - 2009-02-08 : 23:27:29
|
| for example design one table Create table A ( C_1 int , C_2 int, C_3 nvarchar(1000), C_4 nvarchar(1000))design two tables Create table A ( C_1 int , C_2 int, C_3 nvarchar(32), C_4 nvarchar(32))Create table B( C_1 int , C_2 int, C_3 nvarchar(1000), C_4 nvarchar(1000)) |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-08 : 23:52:41
|
| And what is your main question? |
|
|
|
|
|
|
Table design- one table or two tables