Re: Scan and Update

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: David Portas (REMOVE_BEFORE_REPLYING_dportas_at_acm.org)
Date: 01/13/05


Date: 13 Jan 2005 08:11:38 -0800

What is the key here? Every table should have a key but in your sample
it isn't obvious what it is. If the table doesn't have a key then you
should remove duplicates rather than attempt to update them. If you
need more help, please post DDL for the table, including keys and
constraints. See: http://www.aspfaq.com/etiquette.asp?id=5006

-- 
David Portas
SQL Server MVP
--


Relevant Pages

  • RE: Using variable column-names
    ... help, please post DDL, sample data INSERTs and required results. ... David Portas ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL Outer Join Plus Non-Matching
    ... If you need more help, please post DDL, sample data INSERT statements and ... David Portas ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: FETCH CURSOR
    ... If you need more help, please post DDL, some ... sample data and show your required result. ... David Portas ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Cmplex Query
    ... Please post DDL and some INSERT statements for sample data. ... David Portas ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Need a little help please
    ... Every table should have a primary key. ... A lack of indexes and constraints doesn't affect the insert per se. ... David Portas ... SQL Server MVP ...
    (microsoft.public.sqlserver.server)