Latest updates

[5]

SQL Statements



SQL Statements: Generally  we need SQL statements to perform an actions  on a database .                                


Example: The below SQL statement will select all the records in “Persons” TABLE:

SELECT * FROM Persons



Semicolon after SQL Statements?

Some database systems require a semicolon at the end of each SQL statement.
Semicolon is the standard way to separate each SQL statement in database systems that allow more than one SQL statement to be executed in the same call to the server.
We are using MS Access and SQL Server 2000 and we do not have to put a semicolon after each SQL statement, but some database programs force you to use it.






SQL Statements SQL Statements Reviewed by Admin on 04:45:00 Rating: 5

No comments:

Sora Templates