Posted By: CrazyJoe (mudansha) on 'CZdatabases'
Title:     Re: update v SQL serveru
Date:      Fri Jul 18 14:23:07 2003

> > 2] vymeknout a mrknout se na syntaxi do helpu:)
> > 
> >   update t set sl1=xx, sl2=yy where podminka;
> 
> toto je imho "standardni" reseni (uvozovky proto, ze si nejsem
> jist konkretnim standardem, pouze tim, ze tak to dela hodne 
> databazi :)

     Je to standardne aj bez uvodzoviek, definicia SQL-92 hovori:

<update statement: searched> ::=
    UPDATE <table name>
      SET <set clause list>
      [ WHERE <search condition> ]
...
<set clause list> ::=
    <set clause> [ { <comma> <set clause> }... ]

<set clause> ::=
    <object column> <equals operator> <update source>

> pavel

Crazy.

                                 Gijutsu yooi shinjutsu.
                                 Duch je dolezitejsi nez technika.

Search the boards