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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-09-27 : 08:29:30
|
| Janardhanan writes "Microsoft says : "When you use client-side cursors and a command with joined tables, the foreign table fields do not get updated after you change the foreign key value. This article demonstrates how to use the UNIQUE TABLE and RESYNC COMMAND properties to achieve the desired results when the command is a stored procedure. "Even if I specify one table as UNIQUE, in case of a composite key, I am not able to do the update, as sql-server is confused with the same column name in two different tables.Help pls.." |
|
|
|
|
|
Update Stored Procedures with Joined Tables Using ADO