Updating Tables Using a Single Updategram Message in BizTalk Server 2004 and 2006
page 4 of 8
by Naveen Karamchetti
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 35491/ 71

Scenario: Book Store Demo

Book Store Database tables

A Book Store would have the following tables.

1.    Publisher

2.    Books

Listing 2 – SQL Script for creating database and tables

CREATE DATABASE BookStore
GO
USE BookStore
GO
 
CREATE TABLE Publisher
           (
            PublisherID int IDENTITY(1, 1) NOT NULL 
             constraint PK_PUBLISHER_ID primary key,
            PublisherName nvarchar(100) NULL
           )
 
CREATE TABLE Book
           (
            ISBN varchar(10) NOT NULL,
            PublisherID int NOT NULL references Publisher(PublisherID),
            BookTitle varchar(100),
            authorName varchar(100)
          )

View Entire Article

User Comments

Title: Insert in to multiple tables at a time.   
Name: Umesh
Date: 2008-11-27 8:20:12 AM
Comment:
Hi ,
I want to insert data in multiple tables at a time (like header and details ) .
for this purpose i am using Updategram.How can i generate schema for this purpose.

umesh.chpe@gmail.com
Title: Getting invalid namespace error with above sample   
Name: Krishna Sharma
Date: 2007-12-04 6:37:55 AM
Comment:
I am getting "Invalid Schema" error in the send port while inserting data. any help..If you have sample code .plz send
Title: How to update multiple tables   
Name: Gopal
Date: 2007-11-26 10:54:19 PM
Comment:
Above information only tells how to insert into multiple tables, I am trying to update multiple tables could not succeed... I did not find any information on updating multiple tables....

Error

Error details: HRESULT="0x80004005" Description="All updategram/diffgrams nodes with siblings must have ids, either user specified ones or mapping schema based key field id"

Can some one point me in right direction...

Thanks in advance
Gopal

Product Spotlight
Product Spotlight 





Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2024 ASPAlliance.com  |  Page Processed at 2024-02-25 8:11:49 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search