how many tables will create when we create table, what are they? : Sql dba

1141

How to define array in mongoose schema?

65

How do I create a trace in sql server?

1116

How to convert numeric expression data types using the cast() function?

1145

what is sql server agent? : Sql dba

1181

Explain “row_number()” in sql server with an example?

1074

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?

2562

how to use regular expression in pattern match conditions? : Sql dba

1108

Suppose database is running slow, what will you do?

2591

Who proposed the relational model?

1029

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1132

What are the steps in creating a database?

1009

What are the different types of subquery?

1233

please send me oracle pl/sql exp resume. and also faqs...

2569

How do I find the sql server version?

1100