how to insert the values in 5 table at a time with triggers . if u have any so

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

Question Posted / vivek

1 Answers
3662 Views
I also Faced
E-Mail Answers

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

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

Post New Answer

More SQL Server Interview Questions

Define synonym?

0 Answers

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

0 Answers

How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?

1 Answers

Explain microsoft sql server functions?

0 Answers

how to write test cases for testing databases,especially for testing and writing test cases for stored procedures.any real time database testers.please answer me.

0 Answers

How to invoke a trigger on demand?

0 Answers

How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????

3 Answers SAP Labs,

I have a website that allows customers to browse and place orders for certain products. I have 2 tables; Customers and Orders. The Customers table holds the customer records and the Orders table holds the orders placed by the customer. Both tables are tied based on the field Cust_ID. Example of the data is shown below: Cust_ID Cust_Name Cust_ID Product Amount Order_Date 1001 John Tan 1001 P-5211 $120.00 2/13/2006 1002 Michael Wong 1001 K-1428 $88.90 1/11/2006 1003 Mary Cheong 1003 C-0923 $82.50 1/27/2006 1004 Ahmad Suffian 1003 K-1428 $88.90 2/2/2006 Write a single SQL statement that extracts all purchase records with the following criteria: 1. Customer names starting with “M” only. 2. Orders placed within the current month only. 3. Amount does not exceed $100.00 The list must be sorted by order date with the latest order showing on top.

3 Answers Techno Solutions,

how to find 6th highest salary

0 Answers Chetak Logistics,

Can you explain powershell included in sql server 2008?

0 Answers

Is it possible to have clustered index on separate drive from original table location?

0 Answers

Why truncate is ddl?

0 Answers

For more SQL Server Interview Questions Click Here