Skills 
Differences between Row_Number(), Rank(), Dense_Rank() Functions in SQL Server
All three function known as a window function in Microsoft SQL Server, the difference between rank() , dense_rank() , and row_number() ...
Read more →Differences between CAST() and CONVERT() Functions
# CAST() and CONVERT() Functions The CAST and CONVERT functions are both used to convert data from one data type to another. SELECT CAS...
Read more →Difference between Scope_Identity(), @@Identity, and Ident_Current(),Identity().
# SCOPE_IDENTITY () , IDENT_CURRENT , and @@IDENTITY SCOPE_IDENTITY () , IDENT_CURRENT , and @@IDENTITY are similar functions becaus...
Read more →Over and PartitionBy Clause in Sql Server.
# Over and PartitionBy Clause The OVER clause in SQL Server is used with PARTITION BY to break up the data into partitions. The PARTITIO...
Read more →
Differences Between IsNull() and Coalesce() Functions in SQL Server
# Differences Between IsNull() and Coalesce() Functions in SQL Server The ISNULL function and the COALESCE expression have a similar purpos...
Read more →Difference between Identity & Sequence in SQL Server.
# Difference between Identity & Sequence in SQL Server. IDENTITY is a table column property.The IDENTITY property is tied to a particu...
Read more →