Tag: Stored Procedure

By Posted on Posted in CTE No Comments Tagged with , , , , , ,

Transcription of Video: Now on to CTE’s in stored procedures, functions and views. When I first started doing this presentation several years ago, people would ask, “oh, can the CTE be used in a function or can be used in a view”? And the answer to that is yes. And as we saw above, we actually already put the CTE …

CTE’s in Stored Procedures, Functions and Views Read more »

By Posted on Posted in SSMS 1 Comment Tagged with , , , , , , ,

Throughout my career I have worked with different programming and database tools.  Thinking back the tools that I enjoyed using were the tools that were easy to get the job done, and the tools that I hated using were the tools that were the most difficult to use. Being good at what I do means mastering the tools so that …

3 Steps to Work More Efficiently in SSMS. Read more »