how to implement locking in sql server
Answers were Sorted based on User's Feedback
Answer / suraj
like this
select *
from dbo.Address
with (nolock)
-- above query doesn't hold lock while retrieving data.
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / rama krishna
no need to impliment locks sql server automatically holds
locks
Is This Answer Correct ? | 5 Yes | 8 No |
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.
How much memory that we are using in Logshipping Concept?
How to find Duplicate Records In table?
Can two tables share the same primary key?
Do you know what are different types of replication in sql server?
Where are full-text indexes stored?
What is table level trigger?
OPTIMIZATION OF SP,CURSOR,TRIGGERS
How to concatenate two strings in SQL Server.
what is the difference between table and view
What is right outer join in sql server joins?
What is sql server query analyzer?