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 |
|
Cowboy
Yak Posting Veteran
72 Posts |
 Posted - 2008-07-22 : 05:54:16
|
| Hi all, I am starting off a comment/article system in .NET an SQL server 2005 want to keep it as simple as possible for the moment. I have two tables an article table and a comment table; what would be the best method for hooking up these two tables and one where I can reduce my .net code at the same time? a lookup table a foreign key or just create a view when I need to use the data?thanks in advanceI want to build a spaceship with ligthspeed capabilities and I don't even know what a wrench is. |
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-07-22 : 06:23:41
|
| Can you give a little more info, like the colmns you would like in your tables? Do you also want to record the name of the person who wrote the article & some details about them? |
 |
|
|
Cowboy
Yak Posting Veteran
72 Posts |
Posted - 2008-07-22 : 06:32:46
|
| hi, yes for the comments table I record their name, email address, comment, the date (using getdate()) of the post, id and fk articleid (for the moment).for the articles table I have id, title, text, date, author, url.I want to build a spaceship with ligthspeed capabilities and I don't even know what a wrench is. |
|
|
|
|
|
|
two tables comments system design