Interested to Buy Any Domain ? << Click Here >> for more details...
how to insert the values in 5 table at a time with triggers .
if u have any solution then co-operate me ?
- 1 Answers
- 3509 Views
- I also Faced
- E-Mail Answers
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
In what three ways is the return statement used in a stored procedure?
What are the tools available in market as an alternative to sql server reporting services?
Explain full-text query in sql server?
This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?
How to declare and use cursor variables?
How many cores do I need for sql server 2016?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
What are partitioned views and distributed partitioned views?
What is tabulation?
How to disable stored procedure sql server?
What is normalization of database? What are its benefits?
Can you please explain the difference between primary keys and foreign keys?
What is a system database and what is a user database?
How do you implement session management in SQL Server mode?
What is difference between global temporary tables and local temporary tables?
