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

Determine how to use the inserted and deleted pseudo tables?

0 Answers  

---

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  

---

WHAT OPERATOR PERFORMS PATTERN MATCHING?

2 Answers   CarrizalSoft Technologies, CTS,

---

What are partitioned views and distributed partitioned views?

0 Answers  

---

Is t sql the same as sql server?

0 Answers  

---

---

optimization techinques

0 Answers   Wipro,

---

Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,

---

What is the significance of master, tempdb and model databases?

0 Answers  

---

What are the differences between DDL, DML and DCL in SQL?

0 Answers   ABB, Aspire, Infogain,

---

What is xdr?

0 Answers  

---

What is an index. What are the types?

0 Answers  

---

How to disable triggers using "disable trigger"?

0 Answers  

---