What is ? 1) SET ANSI_NULLS ON | OFF
2) SET QUOTED_IDENTIFIER ON | OFF
3) SET NOCOUNT ON | OFF
4) NOLOCK
Difference between throw and throw(ex)
Difference between DISTINCT & GROUP BY
Difference between Overloading & Overriding
Authentication Types
Common Table Expression (CTE)
Can we use INSERT,UPDATE & DELETE in FUNCTION
Consume Web Service without doing "Add Web Reference" in Visual Studio
Which is Faster COUNT(*) or IF EXIST() ?
IEnumerable & IEnumerator
Difference between Abstract Class & Interface
Explain Temporary Table, Table Variable, #temp Table
State Management
Web Services & WCF
Triggers in SQL
Given 2 tables, Apply all types of JOINS in SQL and write the number of records will be returned by each join type.
Types of Session & their implementation
Explain Implementation of Cookieless Session
3 Independent Class as: Class A, Class B, Class C (No Inheritance Between them)
A method ABC() in Class A Should be accessible by Class B and Class C.
But when i add reference of these classes the Method ABC() Should not be accessible by
your project.How can we achieve this ?
How can you fetch the data from other location or webservice using javascript/jQuery or AJAX ?
How many table you would need to maintain a parent-child hierarchies.?
List some SQL Optimization techniques ?
Performance Techniques to show 10 Lacs records on web page ? How can we handle the paging control for same ?
We use public property {get; set;}. Can we use Public variables ? If yes, then why we don' t use ? And If no, then too why ?
What is difference between public variables & Public property ?