What are the different types of lock modes in sql server 2000?
No Answer is Posted For this Question
Be the First to Post Answer
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.
What are the fixed server level roles? : sql server security
What are the source of constraints?
How to get a list of all tables with "sys.tables" view in ms sql server?
What are the indexes in sql server?
1.what is the purpose of using alias name in sql server? with certain example? 2.what is cursor?will u plz explain me in detail with certain example?
What command is used to create a database in the sql server and how?
Do you know what is difference between index seek vs. Index scan?
What are approximate numeric data types in ms sql server?
What is difference between sql and sql server?
 Explain what is sql override for a source taLle in a mapping?
What is Inner Join?