Answer Posted / suhel

This command is not working, I transferred MySQL database
to SQL Server 2000 database.

Please tell me the actual command to use

What is normalization 1nf 2nf 3nf?

1060

---

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

982

---

How and why use sql server?

1007

---

Can sql server 2016 run on windows 7?

916

---

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?

2492

---

What is importing utility?

986

---

How do you size a resultset?

914

---

Which are the olap features?

957

---

Explain the steps needed to create a scheduled job?

933

---

What is analysis service repository?

1023

---

What are the different types of triggers in SQL SERVER?

1138

---

what is create database syntax? : Sql server database administration

1105

---

What is meant by datasource?

924

---

Define inner join? Explain with an example?

996

---

Explain differentiate between a having clause and a where clause?

913

---