BY TOPIC
SQL SERVER BLOGS
SQL BLOGS
- General (11)
- Tables and columns (11)
- Selecting data (7)
- WHERE criteria (5)
- Calculations (8)
- Joins (3)
- Grouping (2)
- Views (2)
- Stored procedures (5)
- SQL programming (5)
- Programming tables (4)
- CTEs, subqueries (6)
- Errors, debugging (2)
- Functions (4)
- Dynamic SQL (3)
- Transactions (3)
- Cursors (1)
- Triggers (1)
BLOGS BY AUTHOR
BLOGS BY YEAR
Blogs from Wise Owl on Stored procedures in SQL
Showing blogs 1-5 (out of 5)
A list of one owl's 5 favourite system stored procedures in SQL!
Posted by Andy Brown on 03 February 2017
Everyone has a favourite system stored procedure (you do, don't you?). But five? That's the subject of this blog, anyway.
Output Parameters and Return Codes in SQL Server
Posted by Andrew Gould on 26 April 2013
This blog teaches you how to return values from your SQL stored procedures using two different techniques: return codes, and output parameters.
Use SQL, parameters and bookmarks to create a grid of clickable links
Posted by Andy Brown on 06 August 2012
To make report navigation easier, you can create a 2-dimensional matrix of clickable links at the top of a report. This blog shows you how!
SQL stored procedures and passing parameters
Posted by Andy Brown on 24 May 2012
Stored procedures are programs in SQL which allow you to pass parameters to queries and manipulate sets of rows in tables. Find out how to write them with this online training blog!
Posted by Andrew Gould on 13 February 2012
This article provides a comprehensive tutorial in Microsoft SQL Server, taking you from the basics of writing SELECT statements all the way through to creating complex stored procedures.