Answer / supriya gupta

SQL Server is a relational database management system
(RDBMS) from Microsoft that's designed for the enterprise
environment. SQL Server runs on T-SQL (Transact -SQL), a set
of programming extensions from Sybase and Microsoft that
add several features to standard SQL, including transaction
control, exception and error handling, row processing, and
declared variables.

What is the difference between primary key and unique constraints?

0 Answers  

---

Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture

0 Answers  

---

Tell me the phases a transaction has to undergo?

0 Answers  

---

How do you find the error, how can you know the number of rows effected by last SQL statement?

1 Answers  

---

Explain what are the restrictions while creating batches in sql server?

0 Answers  

---

What are clustered and non-clustered index?

0 Answers  

---

Where sql server user names and passwords are stored in sql server? : sql server database administration

0 Answers  

---

What is a raid and what are different types of raid configurations?

0 Answers  

---

can primery key be a non clustered index?

10 Answers  

---

How to perform backup for certificates in sql server? : sql server security

0 Answers  

---

how many clustered indexes can be created on a table? : Sql server database administration

0 Answers  

---

How to locate and take substrings with charindex() and substring() functions?

0 Answers  

---