In this blog you will learn how to Insert Multiple Records in Single Query.

Here I am going to show how we can get a list of all stored procedure from a SQL Server Data Base using below Query:

How we can find MAX & MIN salary in a Table Group By Year.

This blog show how to Get Current Financial Year Using SQL Query.

In this blog you will learn how to Get Data From Database using Lambda Expression in SQL using NOT IN(Value,or list of value).

In this blog we learn how to use case statement in update command.

In this blog we learn how to delete duplicate record in sql server without using temp table.

In this blog we learn how to find nth highest salary using Dense_Rank function is SQL.

In this blog we learn how to get the maximum and minimum salary by department in SQL server.

Here I am going to discuss how we could call a stored procedure within a stored procedure and then use the returned value from the executed stored procedure in the caller stored procedure.

This blog describe how to Insert Data into Database using Simple Stored Procedure in SQL.

This blog describes the difference between Delete and Truncate in a SQL query.

In this blog I will show you how to Join Table Valued Function with Table in SQL.

In this blog, I will show How to Reset Identity Column in SQL?

This blog describe how to Get Data from SQL Server without Null Values.

In this blog you will learn how to use WAITFOR query in SQL.

This blog describe the difference between LEN and DATALENGTH function in SQL database.

In this blog you will learn how to Inserting Data From Store Procedure.

In this blog you will learn how to use SP_MSForeachtable in Sql.

In this blog you will learn Scalar-valued Function.