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.

you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

0 Answers  

---

How many types of system privileges are there, Can we add or delete privileges?

2 Answers  

---

Questions regarding Raiseerror?

1 Answers  

---

i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?

5 Answers   Aptech,

---

Is it true that rules do not apply to data already existing in a database at the time the rule is created?

0 Answers  

---

---

Which is faster statement or preparedstatement?

0 Answers  

---

What is checkpoint in sql server?

0 Answers  

---

In the primary key have a multiple field or not?

8 Answers   TCS,

---

Explain primary key?

0 Answers  

---

What is replace and stuff function in sql server?

0 Answers  

---

How do I save a stored procedure in sql server?

0 Answers  

---

What are tables in sql server?

0 Answers  

---