Re: Error in post with ADOSQLServer

Hi,

In a table with over 60000 records? You bet it :)

As a matter of fact it's *always* better to have a primary key that helps
you to:

- search faster, as it is also an index
- identify any record without error possibility, which allows you to never
duplicate (your table should be in 3FN at least)
- update exactly what you need to update, as well as any other operation
like inserts, deletes and modifyings
- in other words, help you avoiding a lot of integrity problems
--
Best regards :)

Guillem Vicens
Dep. informática Green Service SA
www.clubgreenoasis.com
--
In order to send me a mail, remove the -nospam


"Sergio Pottstock" <pttk@xxxxxxx> escribió en el mensaje
news:4299f09a@xxxxxxxxxxxxxxxxxxxxxxxxx
> Thank
>
> That is correct!!!, my table dont have any key.
>
> Allway need primary key for update record?
>
> PTTK
>


.

Relevant Pages

  • Re: PK fields on a table
    ... The Primary Key is indexed to a Block Storage/Memory Address in a seperate table, ... What does matter is the size of the Primary Key field, ...
    (microsoft.public.sqlserver.programming)
  • Too many args when running a stored procedure
    ... no matter how many i try to add, i thought i would try to insert the primary ... key only and work up from there but the primary key insert didnt work ... (@JobNumber) ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Identify selected row in the DataGrids underlying datatable...
    ... Forgot to mention that this a Windows App and that it doesn't really matter ... how I do this as long as I get the Primary key columnof the row that is ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Programmatically enumerate classes?
    ... any given class constitute the primary key. ... Strictly speaking, it's not absolutely ... Looks like it's just a matter of iterating over all the Properties, ...
    (microsoft.public.win32.programmer.wmi)
  • Re: Concatenation
    ... Does this matter when using this approach? ... I was using "primary key" in the relational database sense: ... append two all-NaN columns to m3 ...
    (comp.soft-sys.matlab)