SQL query to find Nth max and min record.

This blog discusses storing numbers of value in one variable in SQL.

This blog discusses the procedure of storing numbers of values with the same data type in one variable in SQL.

Discover how to efficiently swap column values between '1' and '0' in a SQL table using a single query. Learn the art of data manipulation within SQL to update specific column value...

Here we will discuss how to find the duplicity in a column of a Table in SQL.

In this blog you will learn about the sql joins.

This blog help for those people who is new in SQL.

This blog will tell you how to find the created date and last modified date of a stored procedure.

Delete all the Jobs from the SQL Server database

SQL Server Provides Intellisense but makes it more effective and easy to use which consumes your time and less writing code Use SSMS Tool. Really its Just Make programmer life easier. Try It Today.

In this blog we will learn about the ACID properties of the SQL Server which is a commonly asked interview question

This blogs describes how to remove space from a string using sql statement.

You can get count of the day(e.g. Tuesday) between two date(start date and End date) by below script.

NoSQL [Not Only SQL] database is an alternative to traditional RDBMS systems like SQL Server, Oracle and it is having simple, lightweight mechanism for storage and retrieval of data.

This is a Example of Sort Result without using of "Order By" clause.

We have seen most of the freshers and also experienced are confused when to use Functions and when to use Stored Procedures. So I have covered some differences between Functions and Stored Procedur...

Creating stored procedure in MySql.

This blog defines constraints in SQL Server.

In this blog we can enable and disable all login for security reasons.

In this blog I will explain how to Free Disk Space in SQL Server with TSQL Code.