Delete duplicate records in SQL Server

Declare @tbl As table 
(
iid int,
iname varchar(10)
)  

insert into @tbl values(1,'A')
insert into @tbl values(2,'B')
insert into @tbl values(3,'C')
insert into @tbl values(4,'A')
insert into @tbl values(5,'C')

Select * from @tbl 

Delete From @tbl Where iid in (

Select iid from 
(Select * , ROW_NUMBER() Over ( partition by iname Order by iname ) As ICount  From @tbl)

As Qry Where Qry.ICount > 1
)

Select * from @tbl

Comments

Post a Comment

Popular posts from this blog

Draw Line and Text on Bitmap Image in C#

Hello Friends ,  This is a sample Class example of C#,using this code you can Draw the text and line using Graphics pen on Bitmap images. Sample example code (C# Language - VS.Net) ---------------------------------------------------------------------------------------------------------- using System; using System.Drawing; using System.IO; using System.Diagnostics; using System.Data; using System.Drawing.Imaging; using System.Threading; using System.Collections; using System.Globalization; using System.Windows.Forms; using System.Configuration; using System.Net; using System.Net.Mail; using System.Net.NetworkInformation; namespace MyTest { public class GenerateImage { private Thread [] threads; private System.Collections. Hashtable hashConnectionInfo = new System.Collections. Hashtable (); public string appPath = "E:\\MyPenImage\\" ; public GenerateImage()
Read more

Create Folder / Directory using SQL Server

Dear Friends we can use command of command prompt in sqlserver   use   xp_cmdshell   for fire batching command   Like   EXEC   xp_cmdshell   ' Command String ' EXEC xp_cmdshell 'dir *.exe'   to get all directory information EXEC xp_cmdshell 'mkdir kunal' to Create New Directory is deafult path system32 you can set Reference From : http://www.c-sharpcorner.com/Blogs/9569/create-directory-using-sqlserver.aspx 
Read more