In my code i have 3 tables,i have to insert 3 tables data using single insert

In my code i have 3 tables,i have to insert 3 tables data
using single insert query so that i wrote transations in a
sp.but what my problem is,in those 3 tables i have to
include my empId from another table.when i'm passing values
im getting error at this EmpId.
how can i solve this error to execute insert query?
plesae tell me the solution...

Question Posted / anusha

1 Answers
3041 Views
I also Faced
E-Mail Answers

In my code i have 3 tables,i have to insert 3 tables data using single insert query so that i wrot..

Answer / koundinya

before execute the sp you have to get the empID from other
table then you have to call the sp

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More ASP.NET Interview Questions

Just by seeing the signature of the bean how can you specify whether it is a stateful or stateless session bean?

0 Answers

What is http post action?

0 Answers

how to include timer or counting time to display next page in asp.net

0 Answers

I have around 200+ controls in a page. Each of the sets of controls are kept in divs and when header div is clicked, only those div controls pertaining to that header div will be displayed. Rest of the divs are kept invisible. When the page loads, all these 200+ controls are loaded simultaneously, that consumes much of the time. What my requirement is I want to get the div1 controls loaded when the page loads and rest of the div controls should be loaded asynchronously. it should not be loaded with page load, so that time for loading the page can be much minimised. Hope u understood my question and pls help me out with a solution asap....

2 Answers

where the stored procedure are written in business logic or data acess layer?

2 Answers

What is Virtual path in ASP.Net

2 Answers Proteans,

What is ispostback method in asp.net?

0 Answers

Explain the flow of processing of the request? : asp.net mvc

0 Answers

How is session id generated?

0 Answers

Why is validation always done on the server? When does that occur?

2 Answers

What are the different types of caching ?

1 Answers

how can i deploy a asp.net webapplication.in a company so that all employees may access application on their different computers and share a single database. plz tell me the steps to do it..thanks.

1 Answers

For more ASP.NET Interview Questions Click Here