create update statement'

[Ulyssys2009]

Dear All,

I am working on a administrative program for a dental surgery cabinet. I did not get any problem for the INSERT and SELECT statements but i could not find the right syntax for the UPDATE statement.

Can someone refer me to a link where i can find the exact syntax for it, or drop me some line about it.

Thank you in advance

 

[JuggaloBrotha]

Here's a start:
http://www.w3schools.com/Sql/sql_update.asp
http://www.1keydata.com/sql/sqlupdate.html

And a little more complex:
http://www.techonthenet.com/sql/update.php

 

[Ulyssys2009]

Hello JuggaloBrotha,

First Thank for replying. In fact, i need a Website about SQL statement with VB.NET like JDBC for instance.

Thank you again

 

[amitguitarplayer]

Update syntax

as far as i know, the UPDATE syntax is as follows:

UPDATE [tablename] Name1=value, Name2=value etc. WHERE [criteria]


eg.
UPDATE Movies SET MovieTitle='title', MovieDirector='director' WHERE MovieId='Id'

hope this helps