Acces Query

[infosolutionsource]

Hi,

 

can you please send me syntax for Access query, for updating,select and insert?

it is possibel to updating ,make two optional by using "and" "or" for examplle

 

UPDATE database SET Id='1' WHERE ID='0' and Name='james'

 

this query is possibel by using two option with "and"?

 

How can i use also looping to check each records in the database?

 

Thanks!

[SupportTeam]

There are many resources out there that cover SQL query syntax. eg:

 

http://www.w3schools.com/sql/default.asp

 

http://msdn.microsoft.com/en-us/library/office/bb259125%28v=office.12%29

 

http://www.tutorialspoint.com/sql/sql-syntax.htm

 

this query is possibel by using two option with "and"?

Yes. AND, OR can be used.

 

How can i use also looping to check each records in the database?

The SQL command will be automatically carried out to affect all entries in database that match the WHERE clause.