Stored Procedure :supports deffered name resoultion Example while writing a stored procedure that uses table named tabl1 and tabl2 etc..but actually not exists in database is allowed only in during creation but runtime throws error
Function wont support deffered name resolution. Stored procedure returns always integer value by default zero. where as function return type could be scalar or table or table values(SQL Server).Stored Procedure is pre compiled exuction plan where as functions are not.
September 8, 2006 at 8:25 am |
thanks
September 8, 2006 at 8:25 am |
Good one..
September 8, 2006 at 8:26 am |
NIce One……..:)
August 5, 2008 at 11:50 am |
Nice man.. thnx..
August 29, 2008 at 8:22 am |
Storedprocedure is a subprogram which performs some action with in the data base,where as function is asubprogram which is used ti estimate a value
September 23, 2008 at 3:46 am |
Thanks
September 23, 2008 at 3:47 am |
Very Nice…….!
September 23, 2008 at 3:47 am |
Very Nice…….!
September 23, 2008 at 3:49 am |
Good………………………
May 8, 2009 at 3:56 am |
very nice