Searching for ( SQL )

Compare IN List and SQL Table rows and get missing IDs

Added by Nasir Mahmood updated on Friday, July 12, 2019

Here is a small snippet which will used to find missing values provided by IN list in table.


Find Duplicate Records in Table SQL

Added by Nasir Mahmood updated on Friday, November 17, 2017

Having duplicate records in a table is not a problem, but finding duplicate records using SQL query is a problem which we face a lot of time while working with SQL databases.

In this tutorial we will discuss different methods to get duplicate records in table. For this tutorial we are creating a Test table having columns ID, Name and Email by following SQL script



Automate Sql Server Database backup & Restore Using Sqlcmd

Added by Nasir Mahmood updated on Thursday, April 10, 2014

Lets we have to take SQL server’s database backup and then restore it several time in a day using Management Studio. Oh no what a tedious work! Is it not?

Wait here is a good news, we can automate whole process and reduce all work to just a single click. How? Just read this step by step guide and enjoy.


About

32 Tutorials
27 Snippets
6 Products

More

Contact Us

Contact us

Stay Connected