SQL Server Remove Duplicate Records (Rows) from a Table

Introduction:

Here I will explain how to remove duplicate records from a table in SQL server or delete duplicate rows or records in sql server or removing duplicate records using sql server or sql server delete duplicate records or rows from table

Description:

In previous articles I explained about substring function in SQL server and Replace function in SQL Server and I explained how to delete duplicate records from datatable in asp.net. Now I will explain how to delete duplicate records from a datatable in SQL server. 

During work with one application I got requirement like get the unique records from datatable in sql server. Actually our datatable does not contain any primary key column because of that it contains duplicate records that would be like this

SQL Server - Insert Multiple Rows with One Insert Statement

Introduction:

Here I will explain how to insert multiple rows into table with single insert query in sql server or sql server insert multiple records in table with one insert statement with example.

Description:

In previous articles I explained SQL Server Get total rows count in union query, SQL Server Difference between Union and Union All, SQL Server Replace multiple spaces in string with single space, SQL Server Remove html tags from string and many articles relating to SQL server. Now I will explain how to insert multiple rows into table with single insert query in sql server.

To insert multiple rows into table with single insert query in sql server we can follow different methods like as shown below

SQL Server - Get Total Records Count in Union Query

Introduction:

Here I will explain how to get total records count of union query in sql server 2008 or sql server query to get total records of union statement with example.

Description:

In previous articles I explained SQL Server change identity column value,  replace multiple spaces with single space in sql, reseed identity column value in sql server, get only month and year from date in sql server, substring function in SQL server and many articles relating to SQL server. Now I will explain how to get total records count of union query in sql server 2008.

SQL Server - Difference between Union and Union All

Introduction:

Here I will explain difference between UNION and UNION ALL in SQL server. Union operator will return unique records from tables and Union All in SQL server will return all the records from the tables including duplicate values also.

Description:

In previous articles I explained SQL Server change identity column value,  replace multiple spaces with single space in sql, reseed identity column value in sql server, get only month and year from date in sql server, substring function in SQL server and many articles relating to SQL server. Now I will explain difference between UNION and UNION ALL in SQL server.

Generally Union Operators are used to combine the result of two or more select queries into single result set.

SQL Server - Difference between Cursor and While Loop with Example

Introduction:

Here I will explain difference between cursor and while loop in sql server with example or explain cursor vs while loop with example in sql server. Cursors in sql server allow you to fetch a set of data, loop through each record, and modify the values as necessary; then, you can easily assign these values to variables and perform processing on these values. While loop also same as cursor to fetch set of data and process each row in sql server.

Description:

In previous articles I explained While loop example in sql server, nested while loop example in sql server SQL Server change identity column value,  replace multiple spaces with single space in sql, reseed identity column value in sql server, get only month and year from date in sql server, substring function in SQL server and many articles relating to SQL server. Now I will explain difference between cursor and while loop in sql server.

SQL Server Remove (Drop) index from table

Introduction:

Here I will explain how to remove index from table in sql server 2008 or drop index from table in sql server. To remove index from table we use drop index statement in sql server.

Description:

In previous articles I explained create index on column in sql server, SQL Server change identity column value,  replace multiple spaces with single space in sql, reseed identity column value in sql server and many articles relating to SQL server. Now I will explain how to remove index from table in sql server 2008.

To create index on column in sql server that syntax will be like as shown below

SQL Server Create Index on Column in Table with Example

Introduction:

Here I will explain how to create index on column in sql server 2008 or create index on multiple columns in sql server or create index on table in sql server 2008 with example.

Description:

In previous articles I explained SQL Server change identity column value,  replace multiple spaces with single space in sql, reseed identity column value in sql server, get only month and year from date in sql server, substring function in SQL server and many articles relating to SQL server. Now I will explain how to create index on column in sql server 2008.

Install Northwind Pubs Sample Database SQL Server 2008

Introduction:

Here I will explain how to download and install northwind and pubs sample database in sql server 2008 or attach northwind database in sql server 2008 r2  using sql server management studio.

Description:

In previous articles I explained replace multiple spaces with single space in sql, reseed identity column value in sql server, get time difference between two dates in sql, substring function in SQL server and many articles relating to SQL server. Now I will explain how to install northwind sample database in sql server 2008.

To install northwind and pubs sample databases in sql server 2008 you need to follow below steps

SQL Server - How to Remove Special Characters from String in SQL Server 2008

Introduction:

Here I will explain how to remove special characters from string in sql server 2008 with spaces or sql server replace special characters in string with spaces in sql server 2008 or replace unwanted characters in string in sql server.

Description:

In previous articles I explained replace multiple spaces with single space in sql, reseed identity column value in sql server, get time difference between two dates in sql, substring function in SQL server and many articles relating to SQL server. Now I will explain how to remove special characters from string with spaces in sql server 2008.

SQL Server Replace Multiple Spaces in String with Single Space

Introduction:

Here I will explain how to replace multiple spaces in string with single space in sql server or sql server replace multiple spaces with one space in string or sql server remove extra multiple spaces from string without using any while loop.

Description:

In previous articles I explained replace function example in sql server, Query to remove first and last character from string in sql server, remove html tags from string in sql, substring function in SQL server and many articles relating to SQL server. Now I will explain how to replace multiple spaces in string with single space in sql server.

To replace multiple spaces in string with single space in sql server we need to write the query like this

SQL Server - How to Change (Reseed) Identity Column Value in SQL Server 2008

Introduction:

Here I will explain how to change identity column seed value in SQL server 2008 or reseed identity column seed value of table in SQL server or how to change identity column value in SQL server.

Description:

In previous post I explained how set identity or auto increment column in SQL server, Custom auto increment column in sql server, resent identity column in sql server and many articles related to SQL server. Now I will explain how to change or reseed identity column value in SQL server.  I have a one table in that I set identity property on particular column and inserted few records in table while inserting new records identity column value automatically increased that would be like this

How to Remove HTML Tags from String in SQL Server

Introduction:

Here I will explain how to remove html tags from string in SQL Server or how to parse html tags and retrieve only text from string in SQL Server without using regular expressions or remove text between < and > and get only text from string in SQL Server.

Description:

In previous articles I written Can function return multiple values in SQL Server, SQL Server split function to split string with comma, SQL query to get data between two characters range, SQL Server reset identity column to 1 in database, SQL Server acid properties and many articles related to SQL Server. Now I will explain how to remove html tags from string in SQL Server.

To implement this functionality we need to create one user defined function to parse html text and return only text

SQL Server - How to Drop / Delete Column from Table in 2008

Introduction:

Here I will explain how to drop column in SQL Server or delete columns from table in SQL Server 2008.

Description:

In previous articles SQL Query to get list of tables in database, SQL add auto increment column to table, SQL Server ACID properties, SQL date diff function example  and many articles related to SQL Server. Now I will explain how to drop or delete columns from table SQL Server.

SQL Server - How to Get Only Month and Year From Date

Introduction:

Here I will explain how to get only month and year from date in sql server or extract only month and year from date time field in sql server.

Description:

In previous articles I explained get time difference between two dates in sql, sql datediff function to show date difference in days, difference between function and stored procedures, joins in SQL Server, substring function in SQL server and many articles relating to SQL server. Now I will explain how to get only month and year from date in sql server.

Function Example in SQL Server 2008

Introduction:

Here I will explain sql server function example or create function example in sql server 2008. Functions in sql server is used to accept input parameters and it will return single value or table.

Description:

In previous articles I explained difference between function and stored procedure in sql server, can function return multiple values in sql server, Substring function Example, SQL Query to remove first and last character from string, DateAdd function Example, Pass table as parameter to procedure and many articles relating to SQL server. Now I will explain how to use function in sql server with example.

Clearing the Recent Servers List in SQL Server Management Studio

Introduction:

Here I will explain how to clear recent SQL server connection list from dropdown in SQL server management studio.

Description:

In previous articles I explained difference between view and stored procedure in SQL, difference between function and stored procedures, joins in SQL Server, substring function in SQL server and many articles relating to SQL server. Now I will explain how to clear recent SQL server connection list from dropdown in SQL server management studio.

Get Time Difference between Two Dates in SQL Server

Introduction:

In this article I will explain how to get time difference between two dates in SQL server.

Description:

In previous articles I explained SQL DATEDIFF Function to show date difference in days, difference between function and stored procedures, joins in SQL Server, substring function in SQL server and many articles relating to SQL server. Now I will explain how to get time difference between two dates in SQL server.

SQL Sever Datediff() Function to Show Date Difference in Days Hours Minutes

Introduction:

Here I will explain datediff() function in SQL Server with example to get date difference in days hours minutes, years, month between two dates or calculate datediff in SQL Server in days hours minutes format.

Description:

In previous articles I written SQL query to get data between two characters range, Get table size in SQL Server, SQL Server reset identity column to 1 in database, SQL Server acid properties and many articles related to SQL Server. Now I will explain datediff() function in SQL Server to get date difference in days hours minutes between two dates

SQL Server Get Data between Two Characters Range Start with A to C

Introduction:

Here I will explain how to get data between two characters range in SQL server or get user details start with A-C range in SQL server.

Description:

In previous articles I explained Acid Properties in SQL Server, Query to get database size in SQL Server, show time difference in minute ago hour ago etc in SQL Server, can function return multiple values in SQL Server and many articles relating to SQL server. Now I will explain how to get data between two characters range in SQL server.