how to insert the values in 5 table at a time with triggers .
if u have any solution then co-operate me ?
Answer / 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 |
Explain couple pf features of SQL server
What are the indexes in sql server?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
What is BCP? When do we use it?
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration
What is acid db?
When we should use @@error?
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
How to list all login names on the ms sql server?
Why does sql studio use a single registered database repository? : sql server management studio
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.