2 ms·
Only DB portability would be a concern to not used stored procedures, that I can think of. If you want to write an application that can use multiple DBs then yo
by jasfi 4y ago
Only DB portability would be a concern to not used stored procedures, that I can think of. If you want to write an application that can use multiple DBs then you might have a problem.
- scarface74 4y agoEven if you don’t use stored procedures, simple stuff like how you limit the return results is different between databases like SQL Server and MySQL as is how you do bulk inserts. How you specify locks, the support data types, casting, intrinsic functions, conditional statements (case functions) are all different between databases.
- jasfi 4y agoORMs can abstract most things, but not stored procedures.