@sqlite.org
Subject: Re: [sqlite] Can I use internal variables in SQL scripts?
No, because SQLite has no stored procedure capabilities. SQLite has only
simple SQL statements. I'm sure the community would welcome such an
addition, should you or anyone else fancy contributing them:)
Rob Richardson uttered:
In SQL Server, I can write a stored procedure that looks something like
this:
[snip]
Other features available in SQL Server stored procedures include while
loops, temporary tables, and the FETCH command to retrieve data from a
resultset one row at a time.
I have
In SQL Server, I can write a stored procedure that looks something like
this:
CREATE PROCEDURE MyProc AS
DECLARE @someVariable INT
SELECT @someVariable = someColumn FROM someTable WHERE
someConditionThatReturnsOneRow
SELECT someOtherColumn FROM someOtherTable WHERE thePrimaryKey =
3 matches
Mail list logo