Answer / Shyam Kishore Sharma

STUFF replaces a specific substring at a specific position in a string, while REPLACE replaces all occurrences of a substring throughout a string.

What's the difference between DELETE TABLE and TRUNCATE TABLE commands?

9 Answers  

---

How retrieve field names from the table in SQL through JAVA code?

1 Answers  

---

What is the difference between push and pull subscription? : sql server replication

1 Answers  

---

How to turn on the mssql api module in php?

1 Answers  

---

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1 Answers  

---

What do you understand by recursive stored procedures?

1 Answers  

---

What is sparse columns of sql server 2008?

1 Answers  

---

hi ..i am working as a sql dba.....now i want to learn more about t-sql..... is it possible to learn online.... plz refer any site ..thankq

0 Answers   IBM,

---

What is the difference between osql and query analyzer?

1 Answers  

---

How many types of system privileges are there, Can we add or delete privileges?

2 Answers  

---

What are the types of subquery?

1 Answers  

---

How to declare a cursor with "declare ... Cursor" in ms sql server?

1 Answers  

---