how to insert the values in 5 table at a time with triggers .
if u have any solution then co-operate me ?

Answer Posted / raj

write a trigger with 5 insert stmnt in it.
like insert into table1 values();
insert into table2 values();

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Tell me what do we need queues in sql service broker?

508


How to use group functions in the select clause in ms sql server?

529


How to create a simple stored procedure in ms sql server?

513


What is create command?

518


Which tcp/ip port does the sql server run on? How can it be changed?

516






What is the cartesian product of the table?

541


Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

507


When to use null data driven subscription?

144


Explain ranking functions?

599


Why de-normalization required?

564


What are dml triggers and types of dml triggers?

542


Explain what is “asynchronous” communication in sql server service broker?

487


If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

660


What are data files?

575


What are audit control procedures?

580