What are the acid properties?

0 Answers  

---

What is the default Port No on which SQL Server listens?

0 Answers  

---

Diff. b/w Full Outer Join And Cross Join?

3 Answers  

---

List some of the rules that apply to creating and using a ‘view’

0 Answers  

---

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

0 Answers  

---

What is normalization and its types?

0 Answers  

---

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 the second highest salary of an employee?

0 Answers  

---

How can you start sql server in different modes?

0 Answers  

---

Difference between: - Delete & Truncate - Table & View - Constraints & Triggers

1 Answers   United Healthcare,

---

What is the difference between deallocate cursor and close cursor?

0 Answers  

---

In what version of sql server were synonyms released?

0 Answers  

---