Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MelissaTsalicoglou
Starting Member
16 Posts |
 Posted - 2014-06-10 : 04:43:46
|
| HI Would someone be able to explain to me the differences between CTE, SP, view and Functions?I am getting confused between them all ...Seems like SP are similar to MST functions but not sure exactly why and Inline functions similar to views and I really don't get the difference between Views and CTE...Would appreciate a simple explanation on what these differences are if possible? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2014-06-10 : 04:58:07
|
Don't ask for differences please. You can't compare them hence you can't talk about differences.For each point you have mentioned you should google for a documentation about when an why to use...It would be much too much to explain it all here in a thread...SorryFred
Too old to Rock'n'Roll too young to die. |
 |
|
|
|
|
|
Differences explained for CTE , SP , Views and Fun