Answer / Suraj Vikram Shahi

The UNIQUEIDENTIFIER data type in SQL Server is a 16-byte data type that represents a globally unique identifier (GUID). It can be used as a primary key or foreign key, and it guarantees uniqueness across all rows within a database.nExample:n```sqlnCREATE TABLE TableName (Id UNIQUEIDENTIFIER PRIMARY KEY);nINSERT INTO TableName VALUES ('00000000-0000-0000-0000-000000000001');```

Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?

1 Answers  

---

Magic Tables ?

2 Answers   Thomson Reuters,

---

What is transact-sql language?

1 Answers  

---

what type of indexes physically sort data?

3 Answers  

---

How to test odbc dsn connection settings?

1 Answers  

---

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1 Answers   United Healthcare,

---

What is replication with database mirroring? : sql server database administration

1 Answers  

---

Explain concepts of analysis services?

1 Answers  

---

What is buffer cash in sql server?

1 Answers  

---

Write an sql query for deleting duplicate rows?

1 Answers  

---

What is 2nf in normalization?

1 Answers  

---

What is difference between group by and having?

1 Answers  

---