Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2004
    Location
    In cousin's house
    Posts
    303

    Exclamation Unanswered: deleting duplicate record

    hi to all,

    How to delete duplicate record in the recordset?

    Thanks...

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    There must be a dozen ways to do this. Which is easiest and most efficient depends upon your situation.
    Explain your issue in more detail, including how often this will need to be done, and give us the layout of your table.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Oct 2004
    Location
    In cousin's house
    Posts
    303

    Stored procedure

    Hi,

    Thanks for the help but I already delete the duplicate record, but I want to knew what is stored procedure? Can give a sample of a store procedure.


    Thanks..

  4. #4
    Join Date
    Jul 2004
    Location
    Mars
    Posts
    137

    Thumbs up

    A stored procedure is a group of Transact-SQL statements compiled into a single execution plan.

    Stored procedures assist in achieving a consistent implementation of logic across applications. The SQL statements and logic needed to perform a commonly performed task can be designed, coded, and tested once in a stored procedure. Each application needing to perform that task can then simply execute the stored procedure. Coding business logic into a single stored procedure also offers a single point of control for ensuring that business rules are correctly enforced.

    This is just a tip of an iceberg..For more info refer Books online.
    Sudar

    --
    My Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •