Default values are only used if the arguments are not specified. In your case you did specify the arguments – both were supplied, with a value of NULL. (Yes, in this case NULL is considered a real value :-). Try: EXEC TEST() Share and enjoy. Addendum: The default values for procedure parameters are certainly buried … Read more
Stored Procedures are often written in a dialect of SQL (T-SQL for SQL Server, PL-SQL Oracle, and so on). That’s because they add extra capabilities to SQL to make it more powerful. On the other hand, you have a ORM, let say NH that generates SQL. the SQL statements generated by the ORM doesn’t have … Read more
Microsoft recommended using the object_id() function, like so: IF EXISTS (select * from dbo.sysobjects where id = object_id(N'[dbo].[YourProcedure]’) and OBJECTPROPERTY(id, N’IsProcedure’) = 1) DROP PROCEDURE [dbo].[YourProcedure] GO . object_id() helps resolve owner conflicts. If you do SELECT name FROM sysobjects WHERE name=”my_procedure” , you may see many different procedures with the same name — all … Read more
Against stored procedures: business logic in programming space I place a high value on the power of expression, and I don’t find the SQL space to be all that expressive. Use the best tools you have on hand for the most appropriate tasks. Fiddling with logic and higher order concepts is best done at the … Read more
Stored procedures are a sequence of instructions in PL/SQL language. Is a programming language implemented by some DBMS, that lets you store sequences of queries frequently applied to your model, and share the processing load with the application layer. Prepared statements are queries written with placeholders instead of actual values. You write the query and … Read more
The closest thing to an equivalent of a stored procedure in mongodb is stored javascript. A good introduction to stored javascript is available in this article on Mike Dirolf’s blog.