Delete Duplicate Rows in SQL Table

Suppose you have a table and in that table there is this type of duplicate entry then you will have to remove one of entry.
Then You can do it by this command

Delete Top(1) form table_name where id=1

Comments

Post a Comment

Popular posts from this blog

Add Custom Tags in Web config file in ASP .Net

Image
For any reason we want to add some custom tags in web config file but unfortunately these is some predefined tag available for web.config file. To do so we need to create XML file in the format that suits IIS. You can take example of any config present in C:\Windows\system32\inetsrv\config\schema Now create any custom tags and create file and save in the same directory. Now but this is not enough you need to add in applicationhost file as well at C:\Windows\system32\inetsrv\config This will solve your problem and you will be able to add custom config tag in web config file in ASP.Net website.
Read more

SQL Server Failover Clustering in SQL Server 2016 with DNS in Azure

Image
As we know that database mirroring is no longer supported in the latest version of SQL Server i.e. in MS SQL Server 2016. So people are moving toward SQL Server failover clustering as they want to achieve High Availability of database. Here we will setup the things in Azure cloud service, you can enjoy your free subscription of Azure cloud for 1 month. So we can do this in two ways: 1. by using DNS Server which will cost you extra server need more money and maintenance. 2. By using workgroup i.e. without DNS Server this will take less cost in comparison to first one. Best way to do implement SQL Server failover clustering Its all up to your requirement if you have low budget then go without DNS and if have sufficient budget then go with DNS Server extra. Both ways have their own pro and cons so we can't rigid with one way. Steps by Steps to create a   SQL Server Always On Availability Group on Azure Virtual Machines. Create resource group 1)   ...
Read more

How to use AngularJs with MVC C#

Image
So this tutorial is related to JSON data Download the project file form here What we will do in this tutorial? 1. Will know what is JSON data? 2. How to get JSON data returned from a method in C#? 3. How to use them in AngularJs or in Javascript? First start with  what is JSON data? As per Json.org it is Javascript Object Notation which is very lightweight and easy to use for machine and us also. For more details visit : http://json.org/ How to get JSON data returned from a method in C#? So yo can see video here and get to know how it actually works. Steps are as:  Take a empty MVC project and name it what ever you want.  Create a new model StudentDetails (or what ever you want you are free to do so)  Take a controller and it will be good to take Default for learning purpose  Create A JsonResult (Represents a class that is used to send JSON-formatted content to the response.) Type method as mentioned in Video  Create instance o...
Read more