Re: Need a little help please

From: David Portas (REMOVE_BEFORE_REPLYING_dportas_at_acm.org)
Date: 02/16/05 

Date: 16 Feb 2005 12:34:23 -0800

Every table should have a primary key. Why do you have a table without
one?

> Does not having indexes or PK hinder the insert?

A lack of indexes and constraints doesn't affect the insert per se.
Potentially it affects the *validity* of the insert since you won't be
prevented from inserting redundant data.

> And does the order of the
> columns in the insert make a difference?

If all the column names are listed then logically the order makes no
difference. 

-- 
David Portas 
SQL Server MVP 
--

Relevant Pages

  • Re: Scan and Update
    ... need more help, please post DDL for the table, including keys and ... constraints. ... David Portas ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Unique index v. Unique Constraint
    ... > The only thing that's missing is the IGNORE_DUP_KEY option - in SQL2000 ... IGNORE_DUP_KEY is supported for constraints too. ... > David Portas ... > SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Matching on more than one item?
    ... Assuming the primary key is: ... Please include DDL with future posts so that we don't have to guess at keys, ... David Portas ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: show f1 when f2 is not distinct
    ... It does have a primary key, ... "David Portas" wrote: ... > Notice that this ignores NULLs in F2. ... > SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Get the Primary Key of a table
    ... Your query returns ... the nameof the primary key columnnot the name of the key. ... David Portas ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)