Can you call stored procedures?

fsprojects / Rezoom.SQL

Statically typechecks a common SQL dialect and translates it to various RDBMS backends

MIT License

669 stars 25 forks source link

Can you call stored procedures? #35

Closed erlis closed 6 years ago

erlis commented 6 years ago

Hi,

I've been researching Rezoom because I want to access some SQL Server stored procedures but I'm not able to find anything on the documentation for it. Is it supported?

Thanks! Erlis

rspeele commented 6 years ago

Hi,

You can use a vendor statement to call stored procs. Since this bypasses the typechecker, and requires you to manually write an imagine clause if you want to read data coming from the sproc, rzsql's probably not a good fit if your project is mostly stored procedures. On the other hand if you're doing 95% plain queries and only need to run a stored procedure occasionally, the cost/benefit probably works out and it's worth the hassle.

Regards, Robert