rama_kavuri (6/25/2014)
in an interview i have said that the functions are executed at the clients memory and stored procedures are executed at he server sideas long back i have read these on the differences between function and procedures on a web site now when i browse it is not visible may be my search mistakes
can any body correct this give the links where i can find these (MS SQL Server)
Every call made to the sql server is executed on the server side. there is no client side involved. Both have different working in the world of sql server.
you can find hundreds of article u just need to google it.
one of them is this http://stackoverflow.com/questions/1179758/function-vs-stored-procedure-in-sql-server