Answer / suraj

like this

select *
from dbo.Address
with (nolock)

-- above query doesn't hold lock while retrieving data.

Answer / midhun

By using lock hints and Isolation level

Answer / rama krishna

no need to impliment locks sql server automatically holds
locks

Explain the truncate command?

0 Answers  

---

What do you understand by coalesce in sql server?

0 Answers  

---

How do you use a subquery to find records that exist in one table and do not exist in another?

0 Answers  

---

What is ddl command?

0 Answers  

---

How to create an index on an existing table in ms sql server?

0 Answers  

---

---

How does using a separate hard drive for several database objects improves performance right away?

0 Answers  

---

select names starts with a,b,c

8 Answers   Scope International,

---

Tell me what is normalization? Explain different forms of normalization?

0 Answers  

---

How do I setup a sql server database?

0 Answers  

---

How to create user defined functions with parameters?

0 Answers  

---

how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?

9 Answers   Deloitte, Lason,

---

what's the information that can be stored inside a bit column? : Sql server database administration

0 Answers  

---