BY TOPIC
SQL SERVER BLOGS
SQL BLOGS
- General (8)
- Tables and columns (11)
- Selecting data (6)
- WHERE criteria (5)
- Calculations (6)
- Joins (3)
- Grouping (2)
- Views (2)
- Stored procedures (5)
- SQL programming (5)
- Programming tables (3)
- CTEs, subqueries (6)
- Errors, debugging (2)
- Functions (3)
- Dynamic SQL (3)
- Transactions (3)
- Cursors (1)
- Triggers (1)
BLOGS BY AUTHOR
BLOGS BY YEAR
Blogs from Wise Owl on Programming tables in SQL
Showing blogs 1-3 (out of 3)
Speed comparison of temporary tables against table variables
Posted by Andy Brown on 02 March 2017
When you're programming in SQL, you often have the choice of using table variables or temporary tables. This blog considers whether one method is substantially quicker than the other (spoiler alert: not really).
Inline and multi-statement table-valued functions
Posted by Andy Brown on 08 February 2013
This blog shows you how to create table-valued functions in SQL (ie functions which return a table of data!).
How to create and use table variables in T-SQL
Posted by Andy Brown on 08 February 2013
Table variables allow you to hold rows of data in temporary storage, without any processing overhead. Read this blog to add this technique to your SQL armoury!