Answer / pankaj dhatrak

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

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

0 Answers  

---

What do you mean by a dependent functionality in a build?

0 Answers   HCL,

---

What are ddl (data definition language) statements for tables in ms sql server?

0 Answers  

---

What are the steps need to be take improve the speed of a SQLDATA Server?

2 Answers   IBM,

---

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 will happen when a Rollback statement is executed inside a trigger?

1 Answers   Flextronics, Hexaware,

---

Explain intellisense for query editing

0 Answers  

---

How to insert multiple rows with one insert statement in ms sql server?

0 Answers  

---

What is the difference between dataadapter and datareader?

0 Answers  

---

What are the types of joins in sql?

0 Answers  

---

What is the need for indexing?

0 Answers  

---

Difference between 2NF &3NF ?

0 Answers   Cap Gemini,

---