Updating multiple tables in sql server

As I said Stored proc may not be the best way, it depends on a lot of things?

Depending on your front end it may not even be possible to use a stored proc for this. Hi Delerna, I just confirmed with my team lead that we should make use of the stored procedure, Because the font end we are using is JAVA right now.

The SQL Server (Transact-SQL) UPDATE statement is used to update existing records in a table in a SQL Server database.

Then you can put the working pieces back together into the larger task, knowing that that smaller piece is working. Now to the problem of inserting extra records into the PLAN_PDF table.Hi Delerna, If I do not use the stored procedure, I need to update these tables through my application right? We are just creating a helper class in java(which make use of these sp's in the database and call them) and giving it to the other vendor who can actually make use of that code.If so I need to join these 2 tables and do the insert/update from my application. Like I mentioned more than one state can have the same benefit details. In the future if the client want to implement this service class with another .The first table stores the benefit detais as pdf file.(in the PDF_IMAGE column) more than one state is associate with the benefitdetails.(thts why we have plan_pdf table) like 2 states can have the same benefit details. I need to provide a way to the client that he can able to populate these 2 tables through stored procedures.i am wondering that should I write a single sp to do this or I need 2 sp's to acomplish this task.

Leave a Reply

  1. Sex xxl came 28-Jul-2020 05:00

    Speaking of fun, chat line numbers with 30 minutes free trial include diverse options such as interracial black chat lines and Hispanic chat lines for dating black or Hispanic singles.

  2. how importent are evolutionary dating methods 17-Oct-2020 01:30

    cctrl=public,max-age=518400&quality=90&imagesource=IMLFOH&mark=1&watermark=0&width=422&height=315&filename=0599/1044599/1044599O1536362020.jpg" data-r-id="10" data-mn-id="" data-price-id="3" data-price="1.98" data-is-online="true" data-bio-page="/live-sex-chat/cam-girls/Shanaya_Indian" data-freechaturl="" data-is-auto-play="false" data-is-room-full="False" data-no-wr="0" data-has-coupon="1" //i0.wlmediahub.com/imagesrv/imp_getimage?

  3. Chat to a girl free no signup or credit card 26-Apr-2020 21:50

    With the use of modern technology, people can date via telephone or computer or meet in person.

  4. russian dating in beijing 15-Jun-2020 22:19

    At the same time, as you are writing about her, you will probably find things you have in common, like: “I read in your profile that you like fast cars.

  5. link dating site 17-Nov-2019 01:07

    Jillian janson gets screwed on the patio in a purple bikini next picture. Asian Spycam Masseuse Wanking Her Client Joey d gapi si n rozprzestrzeniania swojego adnego buta szeroko otwartego.