Inserting, updating and deleting data using Stored Procedure

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Inserting, updating and deleting data using Stored Procedure

Viewing 1 reply thread
  • Author
    Posts
    • June 27, 2006 at 4:45 PM #13914
      community-content

        Hi,

        I have stored procedure that inserts and updates data to SQL 2000. How can I delete rows? Is updategrams only way to do this in BizTalk 2004?

        examp.
        1. Update tblExmp set colUpdated=0
        2. Exec Proc. (insert/update and Update colUpdated=1)
        3. Delete tblExmp where colUpdated=0

        Br,
        Kaitsu

      • June 28, 2006 at 5:18 PM #13915
        community-content

          When you run the SQL Adapter inside Visual Studio, it builds a schema that allows you to map to the parms of the stored proc.

          I find it easier if the stored proc returns at least one row, even if it is a \”Select return-code\” or something like that. You then do a Send to an Send Port (Request/Response with SQL Adapter) followed by a receive inside the orchestration.

          I have an entire CD dedicated to SQL – see below.

      • Author
        Posts
      Viewing 1 reply thread
      • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.