SQL Q & A

General Topics:

• InterviewQuestions and Answers: Part 1
• InterviewQuestions and Answers: Part 2

SSRS Reports:

• Remove Question Mark (?) and Show Correct Total Number of Pages in SSRS Report

SQL Server:

• Create function to find age as on specific date
• Create Employee and Manager Hierarchy using Common Table Expression
• How to delete duplicate rows using CTE
• Display column names separated with comma
• STUFF Function with example
• Retrieve all Table detail from Known Column in SQL Server
• Get the list of all databases on a server in SQL Server
• Identity Column in SQL Server
• SQL Server isolation Level with example
• Find last day of the month using SQL Server
• How to insert a string value into column with an single quote (apostrophe )

• How to use Count(*) twice in one sql statement
• SQL Query to convert Date from MM/DD/YYYY to YYYY-MM-DD Format
• Difference between COALESCE and ISNULL function in SQL Server
• Difference between IDENTITY, SCOPE_IDENTITY and IDENT_CURRENT in sql server with example