Answer / dinesh

nChar Support Unicode Character but char Does Not
Support

Answer / ruchika mathur

N stands for national character and it is meant for Unicode
data.Using Unicode data types,a column can store the data
defined by Unicode standard. that's why nchar supports
Unicode character whereas char does not.

Answer / parantap

char support ANSI code character but nchar support unicode character.
:-char reserve 1 byte memory space but nchar reserve 2byte memory space.

What is difference between temp table and cte?

0 Answers  

---

What does set rowcount do?

0 Answers  

---

Can we rollback records deleted by a truncate statement?

3 Answers   CarrizalSoft Technologies, United Healthcare,

---

Can truncate be rolled back?

0 Answers  

---

Can a table have 2 foreign keys?

0 Answers  

---

---

Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz

3 Answers  

---

What are the different types of indexes?

0 Answers   Blue Star,

---

what is the difference between Delete and Truncate command in SQL

0 Answers   BirlaSoft,

---

What are the different types of subquery?

0 Answers  

---

Why we need to use secondry database file? though, we can do same work using primary database file also.

2 Answers   Microsoft,

---

difference between truncate, delete aur drop?

2 Answers  

---

What are the different types of backups that exist?

0 Answers   ADITI,

---