Answer / anindya basu

The differences are as under:
a. While Varchar is an ASCII data type, nVarchar is a Unicode data type.
b. While Varchar takes 1 byte per character, Unicode takes 2 bytes per character.
c. While Varchar accepts only Ascii data, NVarchar accepts both Ascii and Unicode data.

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

0 Answers   HCL,

---

How many levels of sp nesting are possible?

0 Answers  

---

What is the difference between a Local temporary table and a Global temporary table? How is each one used?

2 Answers   HCL,

---

Can the query output be sorted by multiple columns in ms sql server?

0 Answers  

---

What is the difference between a local and a global variable?

5 Answers  

---

---

What is a covering index?

0 Answers  

---

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

0 Answers  

---

what is denormalization and when would you go for it? : Sql server database administration

0 Answers  

---

What is the difference between a primary key and a unique key? Are they the same?

0 Answers  

---

can an automatic recovery be initiated by a user? : Sql server administration

0 Answers  

---

Tell me what is difference between view and materialized view?

0 Answers  

---

What happens if null values are involved in bitwise operations?

0 Answers  

---