it is possible to insert first table value and second table

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ashish Srivastava10y ago
http://www.c-sharpcorner.com/code/2529/copy-all-tables-with-data-in-another-database.aspx
0
chiranjit das10y ago
hi Sir,

At first Thanks you given the solution.
0
Joginder Banger10y ago
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
0
Abhay Shanker10y ago
Please clarify your requirement and provide some more details.If possible some sample data you want to store in the table
0