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 |
|
rockmoose
SQL Natt Alfen
3279 Posts |
 Posted - 2005-05-19 : 08:44:16
|
| In .NET IDbCommand Interface there is this property:_______________________________________________________________________________________________________________________UpdateRowSource Description_______________________________________________________________________________________________________________________And You can set it to:Both:Both the output parameters and the first row of a returned resultset may be mapped to the changed row in the DataSet.FirstReturnedRecord:Only the data in the first row of a returned resultset may be mapped to the changed row in the DataSet. None:Any output parameters or rows of a returned resultset are ignored. OutputParameters:Only output parameters may be mapped to the changed row in the DataSet._______________________________________________________________________________________________________________________Both:does not make much sense to me, what if there is a conflict ?, which value is picked, from the returned row or the output parameter.Does anyone know if there are any performance differences between using "FirstReturnedRecord" or "OutputParameters" ?Any preferences for either way ?Personally i am leaning towards "FirstReturnedRecord" as the preferred way.a) You don't have to provide as parameters all of the columns.b) It seems more flexible architecture-wiserockmoose |
|
|
|
|
|
UpdatedRowSource