Showing posts with label programmer. Show all posts
Showing posts with label programmer. Show all posts

Friday, March 30, 2012

NEW to SQL

hi everyone

right now im searching SQL. iwant to study about it. but IM a PLC programmer i dont have background in Database can you help me.
i have a question.

Where can i gprogram SQL what are the software?
Creating database in Access is SQL?

Quote:

Originally Posted by OldSchool

hi everyone

right now im searching SQL. iwant to study about it. but IM a PLC programmer i dont have background in Database can you help me.
i have a question.

Where can i gprogram SQL what are the software?
Creating database in Access is SQL?


Hi. A couple of things.
SQL is a high level database programming language. It will work with several relational database management systems (RDBMS) such as Microsoft SQL Server, Oracle and Access.|||

Quote:

Originally Posted by willakawill

Hi. A couple of things.
SQL is a high level database programming language. It will work with several relational database management systems (RDBMS) such as Microsoft SQL Server, Oracle and Access.


Thanks!

it is just a support not a real stand Alone Program?|||

Quote:

Originally Posted by OldSchool

Thanks!

it is just a support not a real stand Alone Program?


Correct. Access is a stand alone programme. SQL is a language that can be used to define and manipulate data in Access.|||

Quote:

Originally Posted by willakawill

Correct. Access is a stand alone programme. SQL is a language that can be used to define and manipulate data in Access.


thanks!
for example;
i have a table created in MS ACCESS;

Can you site a sample code using ACCESS and SQL?

thanks