Hey folks till now we have discussed User defined functions in sql, Kill Processes in sql server 2008, View in sql ,Remove Cross duplicate
Category: SQL Interview Questions
SQL Server Interview Questions
Recursive SQL Query-2
Recursive SQL Query-2 Lets say I have a table which contains list of Employees of company, which is as shown
Recursive SQL Query
Recursive SQL Query Lets say I have a table which contains list of Employees of company, which is as shown
SQL Query to get desire output-4
SQL Query to get desire output-4 Lets say we have tow tables named with Employee and Department shown as below:
pivot and unpivot in sql server
I have already explained you regarding RANK(), DENSE_RANK(), ROW_NUMBER() , Aggregate functions in sql server and Identity column in sql server. Today I am
How to write SQL Query to get desire output-3
Hello friends, i got one interesting query from some source which i thought to share with you. I want output
Difference between a primary key and a unique key
Both primary key and unique enforce uniqueness of the column on which they are defined. But, there are some differences
Difference between delete and truncate in sql server
Difference between delete and truncate in sql server : Truncate and Delete both are used to delete data from the
OUTPUT Clause in SQL Server
Hello friends, We have already explain regarding IIF() in SQL Server,Right Join in SQL Server,left join in SQL, Self Join
PATH Mode with FOR XML
Hello friends, We have already explain regarding IIF() in SQL Server,Right Join in SQL Server,left join in SQL, Self Join in
EXPLICIT Mode with FOR XML in sql server
Hello friends, We have already explain regarding IIF() in SQL Server,Right Join in SQL Server,left join in SQL, Self Join in
AUTO Mode with FOR XML
Hello friends, We have already explain regarding IIF() in SQL Server,Right Join in SQL Server,left join in SQL, Self Join in