Searching for ( SQLSERVER )

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

29 Tutorials
25 Snippets
6 Products

More

Contact Us

Contact us

Stay Connected