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 |
|
pnpsql
Posting Yak Master
246 Posts |
 Posted - 2012-05-16 : 00:30:11
|
| i have table user that have 2 columns reset and id and i need that when the value of column reset is change to 'Y' THEN ID VALUE IS GET FROM IDMASTER TABLE IDCOLUMN AND UPDATE THE ID IN USER ID COULMN .challenge everything |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-16 : 00:39:42
|
| so does master has only one row? if not , how will you determine which rows id to be updated in user table? or is there another common field between master and user?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
TRIGGER ISSUE