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 the data stores in a page?

1 Answers  

---

What are the properties of the relational tables?

0 Answers  

---

what are the disadvantages of cursors? : Sql server database administration

0 Answers  

---

default databases available in sql server and there uses ?

4 Answers   TCS,

---

Explain primary key in sql server?

0 Answers  

---

Explain system rowset functions?

0 Answers  

---

What is the use of MOVE keyword in restore command

3 Answers   IBM,

---

What is cursor in ms sql server?

0 Answers  

---

What is the fastest way to permanently delete a 1 million row table named customers?

0 Answers  

---

Can we write trigger for view?

0 Answers  

---

What is schemabinding a view?

0 Answers  

---

Where in ms sql server is ’100’ equal to ‘0’?

0 Answers  

---