Welcome, Guest Ohm namah shivoy
www.faqpanel.com
Home | ASP.Net | C-Sharp | Winforms | MS SQL | AJAX | XML | .Net Training*** | Search
Invite friends 
Extras 
VS Tips & Tricks
Top 10 .Net Tools
Special folders in ASP.Net
VS Find Combobox
 ASP.Net Interview Questions and Answers
What is the primary key in SQL Server?
Primary keys are the unique identifiers for each row in a table. They must contains unique values (and hence can not be NULL). Because of their importance in the relational database, primary keys are the most fundamental of all keys and constraints.

A table can a maximum of one primary key. A primary key ensures uniqueness within the columns declared as being part of that primary key and that unique value serve as an identifier for each row.

Which virtual table does a trigger use?
Which operator performs pattern matching in SQL Server?
What are the Stored procedures (sprocs) in SQL Server?
What is DTS (Data Transformation Services) in SQL Server?
Which function is used to find the largest integer less than or equal to a specific value?
What is an execution plan? When would you use it? How would you view the execution plan?
What is the advantage of Materialised View?
What is the use of DESC in SQL Server Query?
If any user-created stored procedure has the same name as a system stored procedure, will the user-created stored procedure be executed?
What is the use of CASCADE CONSTRAINTS?