> BTW I wonder why SQLite doesn't support Stored Procedure. > Through Trigger it does already support some similar functionality. > Certainly, while writing trigger code it won't have been that much code to > write stored procedure code as well..... > That kind of puzzle me.. is there any rationale for the lack of stored > procedure?
Stored procedures are code run by the server. There isn't a server with SQLite. SQLite is a database file structure that uses SQL to access it.