SQL Server Remove (Delete) Duplicate Records from Table using Query

Introduction:

Here will explain how to remove duplicate records or rows from a table in SQL Server or delete duplicate records from table in SQL Server.

Description:

In previous articles I explained take database backup in sql server, covert rows to columns in sql server without using pivot table, substring function in SQL server, Replace function in SQL Server, 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

Take Database Backup in SQL Server 2008 using Query or Management Studio

Introduction:

Here I will explain how to write query to take database backup in sql server or take backup of database using sql server management studio. To take database backup in sql server we need to write query like “BACKUP DATABASE DatabaseName to Disk…etc” or directly from management studio we can take backup  in sql server.

Description:                           

In previous articles I explained SQL injection attacks with example, SQL Server interview question and answers, joins in sql server, function example in sql server 2008, Primary key constraint in sql server, foreign key constraint in sql server, cursor example in sql server and many articles relating to SQL server. Now I will explain how to write query to take database backup or take database backup from sql server management studio 2008.

SQL Server Encryptbypassphrase and Decryptbypassphrase Functions with Example

Introduction:

Here I will explain what is encryptbypassphrase and decryptbypassphrase functions in sql server. By using these functions we can encrypt or decrypt string or text or password column in sql server. EncryptByPassPhrase function in sql server will encrypt the data and store it in varbinary format and DecryptByPassphrase function will decrypt varbinary encrypted string and show the result in decrypted format.

Description:                           

In previous articles I explained SQL injection attacks with example, SQL Server interview question and answers, joins in sql server, function example in sql server 2008, Primary key constraint in sql server, foreign key constraint in sql server, cursor example in sql server and many articles relating to SQL server. Now I will explain use of encryptbypassphrase and decryptbypassphrase functions with example in sql server.

Encrypt and Decrypt String (Password) in SQL Server 2008

Introduction:

Here I will explain how to do encryption and decryption of string or text or password in sql server using encryptbypassphrase and decryptbypassphrase functions in sql server. EncryptByPassPhrase function in sql server will encrypt the data and store it in varbinary format and DecryptByPassphrase function will decrypt varbinary encrypted string and show the result in decrypted format.

Description:                           

In previous articles I explained SQL injection attacks with example, SQL Server interview question and answers, joins in sql server, function example in sql server 2008, Primary key constraint in sql server, foreign key constraint in sql server, cursor example in sql server and many articles relating to SQL server. Now I will explain how to encrypt and decrypt the string or text in sql server.

Calculate Sum of DataTable Columns in Asp.Net using C#, VB.NET

Introduction: 

Here I will explain how to calculate sum of datatable column in asp.net using c#, vb.net or calculate sum of columns in datatable in asp.net using c#, vb.net with example. By using datatable compute property we can calculate sum of columns without having any loops in asp.net using c#, vb.net.  

Description:
  
In previous articles I explained lock user after 3 attempts in asp.net, bind dropdownlist in asp.net gridview using dataset, validate textbox controls inside gridview in asp.net, cascading dropdownlist in gridview using asp.net, change gridview header dynamically in asp.net, Delete multiple rows in gridview using checkbox in asp.net and many articles relating to gridview, asp.net, c#,vb.net and jQuery. Now I will explain how to calculate sum of columns in datatable using asp.net in c#, vb.net.

Google Maps API V3 - Show (Open) Infowindow when Click on Markers in Google Maps

Introduction:

Here I will explain how to show or open infowindow when click on markers in Google maps using Google maps API V3 with example in asp.net website or use Google maps API V3 to open or show infowindow when click on markers in Google maps using jQuery JSON in asp.net website.

Description:

In previous article I explained clearly how to add Google map to website in asp.net, Add marker to Google map in asp.net website, jQuery image slideshow in asp.net, Sitemap navigation control example in asp.net and many articles relating to jQuery, JavaScript, asp.net. Now I will explain how to show or open infowindow when click on markers in Google maps using  Google maps api v3 in asp.net website using jQuery JSON  data.

Google Maps API V3 - Open or Show Only One Infowindow at a Time in Google Maps

Introduction:

Here I will explain how to open or show or keep only one infowindow at a time in Google maps using Google maps API V3 with example in asp.net website or use Google maps API V3 to open or show or keep only one infowindow at a time and close other infowindow in Google maps using jQuery JSON in asp.net website.

Description:

In previous article I explained clearly how to add Google map to website in asp.net, Add marker to Google map in asp.net website, jQuery image slideshow in asp.net, Sitemap navigation control example in asp.net and many articles relating to jQuery, JavaScript, asp.net. Now I will explain how to add click event listener to marker in Google maps using  Google maps api v3 in asp.net website using jQuery JSON  data.

Google Maps API V3 - Add Click Event Listener to Marker in Google Maps Example

Introduction:

Here I will explain how to add click event listener to marker in Google maps using Google maps API V3 with example in asp.net website or use Google maps API V3 to add client event listener to marker in Google maps using jQuery JSON in asp.net website.

Description:

In previous article I explained clearly how to add Google map to website in asp.net, Add marker to Google map in asp.net website, jQuery image slideshow in asp.net, Sitemap navigation control example in asp.net and many articles relating to jQuery, JavaScript, asp.net. Now I will explain how to add click event listener to marker in Google maps using  Google maps api v3 in asp.net website using jQuery JSON data in website.

Asp.Net Populate Google Maps V3 from Database with Multiple Markers

Introduction:

Here I will explain how to populate or show or add multiple markers to Google maps V3 from database in asp.net website using JavaScript or JavaScript populate or Show Google maps with multiple markers from database in asp.net.

Description:

In previous article I explained clearly how to add Google map to website in asp.net, Add marker to Google map in asp.net website, JavaScript Add multiple markers to google map, jQuery image slideshow in asp.net, Sitemap navigation control example in asp.net and many articles relating to jQuery, JavaScript, asp.net. Now I will explain how to populate Google maps from database with multiple markers in asp.net website.

Google Maps API V3 - Populate (Show) Google Map Markers from Array of JSON Data

Introduction:

Here I will explain how to populate or show google maps markers from array of JSON data using Google maps API V3, jQuery in asp.net website or use Google maps API V3 to populate google map from array of markers with info windows using Google maps API V3 using jQuery JSON in asp.net website.

Description:

In previous article I explained clearly how to add Google map to website in asp.net, Add marker to Google map in asp.net website, jQuery image slideshow in asp.net, Sitemap navigation control example in asp.net and many articles relating to jQuery, JavaScript, asp.net. Now I will explain how to populate google maps from array of markers with info windows using  Google maps api v3 in asp.net website using jQuery JSON data in website.