Explain cdc and sql injection?

0 Answers  

---

What is plan freezing?

0 Answers  

---

When do you create cluster and noncluster index?

5 Answers   Satyam,

---

What are the different ways you can create databases in sql server?

0 Answers  

---

explain different types of jions with examples briefly?

1 Answers   Zensar,

---

What is scan table/view and seek table/view when its occurs? : sql server database administration

0 Answers  

---

Define right outer join?

0 Answers  

---

Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables?

1 Answers   HP,

---

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,

---

Do you know what is openxml in sql server?

0 Answers  

---

What does it mean to have quoted_identifier on? What are the implications of having it off?

2 Answers  

---

what is cursor?why we will go to cursor?advantages &disadvantages of cursors?

1 Answers  

---