Give main differences between "Truncate" and "Delete".

0 Answers   HCL,

---

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

0 Answers   MCN Solutions,

---

Can a trigger be created on a view?

0 Answers  

---

What types of replication are supported in sql server?

0 Answers  

---

What are subquery and its properties?

0 Answers  

---

What are the advantages of using a stored procedure?

0 Answers  

---

Which one is faster delete/truncate? Why?

1 Answers   Infosys,

---

How to Generate a Series of Random Integers With T-SQL?

1 Answers  

---

You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?

0 Answers  

---

Is it possible in sql table to have more than one foreign key?

0 Answers  

---

i need to know how i display department which has salary > =5000 for the below table Department ----------- salary deptname 1000 a 3000 a 2000 b 3000 b 4000 c 5000 c kindly send the query to thilakvinoth13@gmail.com

6 Answers  

---

How do you clear a log file?

0 Answers  

---