Can we create clustered index on composite key?

0 Answers  

---

What are different types of table joins?

0 Answers  

---

There are two tables (T1, T2) with different rows. Find the output of query. Select count(*) from T1,T2.

3 Answers   Amdocs,

---

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,

---

What are different types of constraints?

0 Answers  

---

---

What are distinctive joins find as a part of sql?

0 Answers  

---

What is your recommendation for a query running very slow? : sql server database administration

0 Answers  

---

What is subquery explain with example?

0 Answers  

---

Can we update data in a view?

0 Answers  

---

Mention a few common trace flags used with sql server?

0 Answers  

---

Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance

1 Answers  

---

What is a partition key?

0 Answers  

---