What is difference between TRUNCATE and DELETE statement

12 Answers   CTS,

---

Is it possible to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static field info. If so How?

1 Answers  

---

Does a full backup include transaction log?

0 Answers  

---

Can sql servers link to other servers like oracle?

0 Answers  

---

What does top operator do?

0 Answers  

---

---

How to configure and test odbc dsn settings?

0 Answers  

---

What are the types of model in sql server and explain

2 Answers   TCS,

---

how to update a null value field in sql server eg a table contains 3 fields id,name,salary and 3 records salary of 1 record is null i want update the nullfield 111 arun 300 112 ddd 200 113 ttt null i want to update table with add 100 to every record include null after updation the recrds should be 111 arun 400 112 ddd 300 113 ttt 100

6 Answers   ABC, HCL,

---

How we can compare two database data?

0 Answers  

---

Does partitioning improve performance?

0 Answers  

---

How to drop an existing stored procedure in ms sql server?

0 Answers  

---

What keyword you will use to get schema appended to the result set of a ‘for xml’ query?

0 Answers  

---