what is the main difference between constraints(like primary key etc..)& joins?

2 Answers  

---

Define right outer join in sql server joins?

0 Answers  

---

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

0 Answers  

---

What are Row versions of DataRow?

0 Answers  

---

What is the appropriate number of test cases that you can write on a database?

2 Answers   Microsoft,

---

Where is localdb stored?

0 Answers  

---

How to drop an existing table?

0 Answers  

---

What is difference between getdate and sysdatetime in sql server 2008?

0 Answers  

---

What is the stuff and how does it differ from the replace function?

0 Answers  

---

How to create prepared statements using odbc_prepare()?

0 Answers  

---

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?

0 Answers   TCS,

---

What are diverse clauses that form a part of sql?

0 Answers  

---