What are the differences between lost updates and uncommitted dependencies?

0 Answers  

---

What is the disadvantage of using subquery exact after a select statement?ex. select (select * from sometable)

1 Answers  

---

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

0 Answers  

---

What is difference between sql and sql server?

0 Answers  

---

Can we hide the definition of a stored procedure from a use?

0 Answers  

---

---

What to perform pattern match with the like operator?

0 Answers  

---

how to determine the service pack currently installed on sql server? : Sql server database administration

0 Answers  

---

Why I have to use stored procedures?

0 Answers   Cognizant,

---

How to use transact-sql statements to access the database engine?

0 Answers  

---

explain declarative management framework (dmf) in sql server 2008?

0 Answers  

---

When do you use SQL Profiler?

3 Answers   Wipro,

---

Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0

7 Answers   PMAM IT Services, TCS,

---