What is the difference between Inline table function of SQL and SP?what is the need of of each one? when we prefer one to the another ?
Read:
http://blogs.msdn.com/b/pradeepsvs/archive/2014/10/09/difference-between-a-stored-procedure-and-function.aspx
http://stackoverflow.com/questions/1179758/function-vs-stored-procedure-in-sql-server
You need to learn how to find these type of information and read them through first.
They are two different things. When you pick up the basic about both, you can code in TSQL to solve your problem with either or both in a particular scenario.
Mr Khan
both are different thing its depend on you where you want to use which one. Generally i prefer Store procedure.
Can anyone tell me the scenario for using one in preference to the other one?
