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… Read More »CTE’s in Stored Procedures, Functions and Views
CREATE PROCEDURE #MyProcedureName
Yes, you can create temporary stored procedures by prefixing the name of the sproc with a #. The temporary stored procedure is sort of a “leave no trace” stored procedure that is only good for your session. If you use double ## you will get a global temporary stored procedure.
For instance:
Today I released the latest update to Database Health Monitor. Version 2.4.2. It has been about a two weeks since version 2.4.1 release and version 2.4.2… Read More »Database Health Monitor Version 2.4.2 Released Today
Today I released another beta release of SchemaDrift. Part of this release was some redesign of the main screen, as shown here. I had some great… Read More »Beta release 1.2 of SchemaDrift – the database schema comparison tool
Today I am at SQL Saturday Portland Oregon, and at 9:00am I am presenting the Introduction To Common Table Expressions session: Here is the abstract:… Read More »Introduction to CTEs Slides and Sample Queries
Related Common Table Expression Links Sample Database for Common Table Expressions Writing Your First Common Table Expression with SQL Server Video: Writing Your First… Read More »What is a Common Table Expression – Video
June was an exciting month for me with Beta 6 of the Database Health Reports releasing at the beginning of the month, and this being… Read More »End of June Summary
Day 15 of Common Table Expression Month (June) at SteveStedman.com, today we will be taking a look at data paging with CTE’s in a function. Yesterday… Read More »CTE Data Paging in a Procedure
Day 14 of Common Table Expression Month (June) at SteveStedman.com, today we will be taking a look at data paging with CTE’s and how it compares… Read More »CTE Data Paging
Day 12 of Common Table Expression Month (June) at SteveStedman.com, today we will be taking a look at how to use multiple nested CTEs in a… Read More »Nested CTE’s Gone Wild – The Video