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 |
|
Kristen
Test
22859 Posts |
 Posted - 2005-09-08 : 12:24:54
|
| Can you impliment a trigger to cascade a change to the PK when there is no other, non-changing, unique data in the table?If so perhaps you could put sort out this topic pls:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=54949(Posted here on the assumption that busy folk skip topics that have traffic ...)Kristen |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-09-08 : 22:11:14
|
actually the department name is kinda unique coz it's a departments table and we can kinda get a relationship between inserted and deleted tables  hope that helps...--------------------keeping it simple... |
 |
|
|
|
|
|
Foxed