Answer / tauseef

unique identifier data type size is 16 bits.
while creating table we have to create unique identifier
datatype column. it will create unique identity column
with 32 charcters and not 16 characters

Answer / ranjit kumar routhu

unique identifier data type size is 16 bits.
while creating table we have to create unique identifier
datatype column. it will create unique identity column
with 16 charcters
ex: create table a( id uniqueidentifier default newid
(),....),newid() generates new 16 unique charcter values

How do I view a stored procedure in sql server?

0 Answers  

---

Scalability, Availability, Integration with internet, etc.)?

0 Answers  

---

What is the difference between temp table and table variable?

8 Answers   Microsoft,

---

Which trace flags are enabled in sql server?

0 Answers  

---

Can multiple columns be used in sql group by clause in ms sql server?

0 Answers  

---

---

What do you mean by data integrity?

0 Answers  

---

What is triggers and stored procedures?

0 Answers  

---

What is the difference between truncate and delete statement?

6 Answers   CarrizalSoft Technologies, CTS,

---

What are the advantages of user defined function?

0 Answers  

---

Tell me about pre-defined functions of sql?

0 Answers   EXL,

---

What are the difference between primary key and unique key? : sql server database administration

0 Answers  

---

Is it possible to create trigger on views?

0 Answers  

---