SQL Q & A

General Topics:

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

Complete Emp and Dept table with example

Interview questions on emp and dept table (part 1)
Interview questions on emp and dept table (part 2)
Interview questions on emp and dept table (part 3)
Interview questions on emp and dept table (part 4)
Tricky interview questions employee and manager column in emp table
Tricky interview questions employee and manager column in emp table

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