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 |
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
 Posted - 2009-12-10 : 14:02:44
|
| greetings,i want to have a lookup table with first row that is hidden from users and has a PK or some other key that is -1, but never show this row to users.purpose is to have any new rows that create in another table that referes this lookup table to have default value -1.hope this is clear..Thanks<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
|
|
shan
Yak Posting Veteran
84 Posts |
Posted - 2009-12-10 : 14:09:11
|
| Can you create a view and just dispaly only the columns that are needed from the table.-Shan |
 |
|
|
|
|
|
default value for unmapped items