Welcome, Guest Home | ASP.Net | C-Sharp | Winforms | MS SQL | AJAX | XML | .Net Training*** | Search

Login here Email-Id: Password: Register Now Change Password Forgot Password? Why Register? Invite friends  Extras  VS Tips & Tricks Top 10 .Net Tools Special folders in ASP.Net VS Find Combobox  ASP.Net Interview Questions and Answers How to find out column names and their datatypes in a given table using a query in SQL Server? Using the table tablename, write the query as follows - Select * from information_schema.columns where table_name = tablename What is the difference between a primary key and a unique key? What are some SQL aggregates and built-in functions? How to find nth highest salary from Employee table in SQL Server? What are the types of constraints in SQL Server? What are the steps you will take to improve performance of a poor performing query in SQL Server? TRUNCATE TABLE EMP;, DELETE FROM EMP; -What Will the outputs of the above two commands (Queries) in SQL Server? What is a transaction and what are ACID properties? What is the CHECK constraint in SQL Server? What is the DEFAULT constraint in SQL Server? What is the advantage of SET NOCOUNT ON?

ASP.Net Interview Questions and Answers (FAQs) | C-Sharp (C#) Interview Questions and Answers (FAQs) | Winform (Windows Forms) Interview Questions and Answers (FAQs) SQL SERVER Interview Questions and Answers (FAQs) | AJAX Interview Questions and Answers (FAQs) | XML Interview Questions and Answers (FAQs) © www.faqpanel.com: 2009-2010,  All Rights Reserved   |  Privacy Policy | Terms and Conditions