Re: "DataSet" input parametes to Stored Procedures

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Kevin Yu [MSFT] (v-kevy_at_online.microsoft.com)
Date: 10/12/04 

Date: Tue, 12 Oct 2004 06:26:25 GMT

Hi Patrick,

I'm not quite familiar with Oracle. But in SQL Server, we have to tell the
database what to update (filter) and how to update. These are passed as
parameters in a command object in ADO.NET. I don't quite understand if we
pass a long list of text, how does the stored procedure know what is the
filter and which one is the new value to update?

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

Relevant Pages

  • Re: Why not Access...?
    ... Next, I DID NOT SAY Oracle was considered a "best choice," only a sufficient ... It is a desktop application and the database in also on the same machine. ... I also want to know why Oracle is considered a best choice as compared to SQL Server. ... > Also, you need to answer the question regarding whether or not each client> will be using an individual database, and individual copy of a central> organization database, or making straight calls to a centralized ...
    (microsoft.public.sqlserver.server)
  • Re: SQL renamed expression name not recognised in WHERE
    ... OP's original query and my nested table expression ... directive as a filter on a derived value only. ... The corrected version (which run equally well under SQL Server and Oracle ...
    (comp.sys.ibm.as400.misc)
  • Re: Merge/Replication or Syncing with Oracle
    ... You can't directly access an Access database on the desktop from a WM 5 app, but you can sync between SQL Compact on the WM device and Access using the Access Syncronizer: ... As for the Oracle issue ... ... Where SQL Compact Edition easily does merge/replication to SQL Server using IIS ... ...
    (microsoft.public.sqlserver.ce)
  • Re: Oracle vs SQL Server as a back end for Access?
    ... post -- comparing back end database engines or replacing the front end ... say that Oracle 10g is better than SQL Server 2000 without determining ... whether or not the total cost of ownership of 10g over SQL Server ... developer than Oracle 10g, in spite of its new web interface. ...
    (comp.databases.ms-access)
  • Re: Oracle licence question
    ... And no - it does not freeze anything, the backups DO NOT affect connections ... SQL Server MVP ... freeze the database and send it to the target. ... What I really wanted is something that lists features I get in Oracle ...
    (comp.databases.oracle.server)