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).

Tags:   SQL | Programming tables

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!).

Tags:   SQL | Programming tables    |    T-SQL | SQL Tutorial

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!

Tags:   SQL | Programming tables    |    T-SQL | SQL Tutorial
This page has 0 threads Add post