Answer / pankaj dhatrak

Truncate is more faster
reason truncate direct drop the data page and not save the transactions.

If you are working on a SQL database and if suddenly a developer changes the code and your queries results start giving errors,how will you check using a T-SQL query (on system tables) that what has changed in the database.

2 Answers   Microsoft,

---

Can XML be used to access data?

2 Answers  

---

Differentiate between a local and a global temporary table?

0 Answers  

---

Can we return Data from 4(more than 1) tables in stored procedure?

0 Answers   HCL,

---

What is truncate table?

0 Answers  

---

---

Can primary key be a foreign key?

0 Answers  

---

How to use go command in "sqlcmd"?

0 Answers  

---

What is a file group?

0 Answers  

---

How to find the date and time of last updated table?

3 Answers  

---

Hi Friends, I have a table in which there are thousands of records and in city field there is NULL value for all records now i want to change that null value with distinct values in each record say delhi, bihar, agra, jaipur etc, what will be the query for that????? its not possible to update thousands of records one by one. is there any alternative ...? Plz help ... its urgent Thanx in advance

1 Answers  

---

What according to you is the difference between mysql and sql server performance?

0 Answers  

---

Explain a join?

0 Answers  

---