passing multiple row valur to stored proc

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

passing multiple row valur to stored proc

Author

Topic

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2012-02-22 : 02:14:38

Hi All,

We have 2 tables one is tender table and another one is tender_product table. From the front end(.net app) user try to update tender by editing product details.We need to pass/update those values to tender_product table-- how do we do this.

We need to pass all the rows value to stored proc ???

Thanks,
Gangadhara MS
SQL Developer and DBA

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-02-22 : 09:45:49

something like this?


http://visakhm.blogspot.com/2010/04/using-xml-to-batch-load-master-child.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

gangadhara.ms
Aged Yak Warrior

549 Posts

Posted - 2012-02-22 : 21:02:53

But my total number number rows values are high,even its more than 8000 characters how do we handle this.

Thanks,
Gangadhara MS
SQL Developer and DBA

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-02-23 : 09:14:04

quote:
Originally posted by gangadhara.ms

But my total number number rows values are high,even its more than 8000 characters how do we handle this.

Thanks,
Gangadhara MS
SQL Developer and DBA

what difference does it make?
i just showed an example with XML
you can simply use tow inserts instead.
the key is usage of OUTPUT clause not XML input

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources