Inserting in Multi table With one Store Procedure
-
Hi, I have a form which including different sort of information. for instance, some information is regarding to personal data which related to Table1 and some are for Table2 and the some are for Table3. all this information are in 1 form. Now, I just wondering to know, when I wanna insert data via Store procedure do I have to write SP for each of them? is there any approach to insert data with writing just one SP.
-
Hi, I have a form which including different sort of information. for instance, some information is regarding to personal data which related to Table1 and some are for Table2 and the some are for Table3. all this information are in 1 form. Now, I just wondering to know, when I wanna insert data via Store procedure do I have to write SP for each of them? is there any approach to insert data with writing just one SP.
-
Hi, I have a form which including different sort of information. for instance, some information is regarding to personal data which related to Table1 and some are for Table2 and the some are for Table3. all this information are in 1 form. Now, I just wondering to know, when I wanna insert data via Store procedure do I have to write SP for each of them? is there any approach to insert data with writing just one SP.
future3839 wrote:
Now, I just wondering to know, when I wanna insert data via Store procedure do I have to write SP for each of them? is there any approach to insert data with writing just one SP.
Get the data in parameters and based on their name, in which db you need to insert. Are you asking something else?
Cheers!! Brij Visit my Blog: http://brijbhushan.net
Check my latest Article :ViewState - Various ways to reduce performance overhead