it is possible to insert first table value and second table

Question

dear sir it is possible to insert first table record and automatically insert second table record corresponding first table record Please Help me

Ashish Srivastava · Answer

http://www.c-sharpcorner.com/code/2529/copy-all-tables-with-data-in-another-database.aspx

chiranjit das · Answer

hi Sir, At first Thanks you given the solution.

Joginder Banger · Answer

Hi ChiranJit Das G.. I respect DAS because DAS is my sir in company so nice man. I come to your point. Sql server give your function after insert in table and before data insert in table you can get or do any thing as per your requirements. -- Create trigger on table Employee_Demo for Insert statement CREATE TRIGGER trgAfterInsert on Employee_Demo FOR INSERT AS declare @ empid int , @ empname varchar ( 55 ), @ empsal decimal ( 10 , 2 ), @ audit_action varchar ( 100 ); select @ empid = i . Emp_ID from inserted i ; select @ empname = i . Emp_Name from inserted i ; select @ empsal = i . Emp_Sal from inserted i ; set @ audit_action = 'Inserted Record -- After Insert Trigger.' ; insert into Employee_Demo_Audit ( Emp_ID , Emp_Name , Emp_Sal , Audit_Action , Audit_Timestamp ) values (@ empid ,@ empname ,@ empsal ,@ audit_action , getdate ()); PRINT 'AFTER INSERT trigger fired.' --Output will be --Now try to insert data in Employee_Demo table insert into Employee_Demo ( Emp_Name , Emp_Sal ) values ( 'Shailu' , 1000 ); --Output will be for more information about trigger lot's of example are available on google . http://www.dotnet-tricks.com/Tutorial/sqlserver/OPUH170312-After-Trigger,-Instead-of-Trigger-Example.html

Abhay Shanker · Answer

Please clarify your requirement and provide some more details.If possible some sample data you want to store in the table

it is possible to insert first table value and second table

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (4)