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

What is page in sql server?

0 Answers  

---

To which devices can a backup be created and where should these devices be located? : sql server management studio

0 Answers  

---

List down some advantages of sql stored procedure?

0 Answers  

---

If a table does not have a unique index, can a cursor be opened on it?

0 Answers  

---

What is always encrypted?

0 Answers  

---

i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,

---

What are mdf,ndf,ldf files and how to see the data in those files?

6 Answers   Accenture,

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

0 Answers  

---

What are the difference between primary keys and foreign keys?

0 Answers  

---

Explain about protocol layer present in SQL server?

0 Answers  

---

What types of replication are supported in sql server?

0 Answers  

---

what is hash table

3 Answers   ILFS, Teledata,

---