how to retive value of a column of another table in store pr

Question

how to get value of another column of a table to insert in a column of a table with some entered value for other column from textbox for rest of columns

Khan Abrar Ahmed · Answer

Hi Could please explain more which column you want to compare and what data u want to insert in the third table 3 table classroom1[student_name,age,roll] and classroom2[student_name,age,roll] and studentdetails[same_age_student(int),name]

Susanta Rout · Answer

i want to insert in third table the matched column of table 1 and table 2

Ramesh Maruthi · Answer

Hi Susanta, Write a stored proc: 1) After entering the values in TB, you will click on button I guess. So in that click event you need to call the stored proc either by ADO.net or ORM 2) Simple summary how a stored proc should be: First you need to insert the values in the Table 1 After inserting into table1, write an insert sql auery into table 2 And write select query and select column you want from table1

Susanta Rout · Answer

i want to get number of row of two table where both column match of that two table and insert into a column of another table in store procedure with rest column from from my interface for example i have 3 table classroom1[student_name,age,roll] and classroom2[student_name,age,roll] and studentdetails[same_age_student(int),name]

Khan Abrar Ahmed · Answer

Hi could you please explain more, if you want to insert values in sql server you can try like this insert into table1 (c1,c2) select t2.C1,t2.C2 from table2 t2 --this is second table

how to retive value of a column of another table in store pr

Answers (5)