User Profile

Collapse

Profile Sidebar

Collapse
rajeshkrsingh
rajeshkrsingh
Last Activity: Feb 11 '08, 01:23 PM
Joined: Oct 4 '07
Location: Delhi,India
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • rajeshkrsingh
    replied to How to Delete Duplicate Record in sql server 2000
    in SQL Server
    Hi friends,

    Step1-
    create table duplicate
    (
    intId int, varName varchar(50)
    )
    insert into duplicate(intId ,varName) values(1,'rajes h')
    insert into duplicate(intId ,varName) values(2,'raj12 ')
    insert into duplicate(intId ,varName) values(1,'rajes h')
    insert into duplicate(intId ,varName) values(2,'raj12 ')
    insert into duplicate(intId ,varName) values(3,'raj12 ')

    Step2-...
    See more | Go to post

      Leave a comment:

    • rajeshkrsingh
      started a topic Delete Duplicate record from SQL Server2000
      in SQL Server

      Delete Duplicate record from SQL Server2000

      Hi friends,

      Step1-
      create table duplicate
      (
      intId int, varName varchar(50)
      )
      insert into duplicate(intId ,varName) values(1,'rajes h')
      insert into duplicate(intId ,varName) values(2,'raj12 ')
      insert into duplicate(intId ,varName) values(1,'rajes h')
      insert into duplicate(intId ,varName) values(2,'raj12 ')
      insert into duplicate(intId ,varName) values(3,'raj12 ')

      St...
      See more | Go to post
      No activity results to display
      Show More
      Working...