I am starting to work with Sqlite and I wanted to ask if there is any way to create a stored procedure that stores values, sent from the front end, in variables to work with queries? as in common Sql
for example I have:
@nombre varchar(50),
@estado varchar(50)
insert into tabla 1 (Nombre, Estado) values (@nombre, @estado)
Can something like that be done in SQLite?
I also wanted to know if it is possible or if there is a way to get the current date and time in SQLite as the GETDATE of the SQLserver