Topic: Differences

Can any one about differences in SQL script and SQL queries and their uses? Any web page from where I get stuff about them?

Re: Differences

Hi unforgettable,

I reference https://www.sqlitetutorial.net/ a lot for SQL lite stuff.

As far as scripts, put your queries inside the SQLExecute() function.

And for calculated fields, surround the query in (parentheses).

-joshuA

"Energy and persistence conquer all things."

3 (edited by k245 2022-06-17 05:49:46)

Re: Differences

SQL queries are SQL commands for retrieving or manipulating data.


A SQL script is a sequence of SQL commands that can be executed sequentially.


There is an extension of the SQL language - PSQL, which includes commands for creating variables, controlling the sequence of script execution, and more. This extension is used when writing stored procedures - scripts that are executed on the database server side.

Визуальное программирование: блог и телеграм-канал.