BY TOPIC
SQL SERVER BLOGS
SQL BLOGS
- General (12)
- Tables and columns (11)
- Selecting data (8)
- WHERE criteria (5)
- Calculations (8)
- Joins (3)
- Grouping (2)
- Views (2)
- Stored procedures (5)
- SQL programming (6)
- 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
Wise Owl Training - SQL blogs (page 3 of 4)
Showing blogs 41-60 (out of 72)
Posted by Andrew Gould on 16 January 2013
When you write queries in SQL it's immensely useful to be able to show records matching criteria that you've set. You can do this using the WHERE clause and this blog teaches you how to use it!
Declaring and using SQL variables
Posted by Andy Brown on 03 January 2013
Variables in SQL always begin with @, and allow you to program more efficiently. Learn the tips and tricks in this short series of blogs!
Creating views in T-SQL or in the view designer
Posted by Andy Brown on 17 December 2012
Views are queries that you can save and reuse; but you can also use them as a basis for further queries. They do have their foibles too, as this blog explores.
Use the GROUP BY clause in SQL for statistics
Posted by Andy Brown on 14 December 2012
If you want to average, count, sum or perform any other statistic on values in SQL, you need to learn the GROUP BY and HAVING parts of a SQL statement. That's where this online tutorial comes in!
How to do calculations and expressions in T-SQL
Posted by Andy Brown on 11 December 2012
You can use SQL to do everything from simple arithmetic through to complicated functions - this blog gives you the low-down!
Creating computed columns in SQL tables
Posted by Andy Brown on 10 December 2012
This short blog explains how you can create calculated formulae for fields in an SQL table (known as "computed columns").
Writing inner joins and outer joins in SQL
Posted by Andy Brown on 30 November 2012
An in-depth SQL tutorial on how to create inner joins, left outer joins, right outer joins, full outer joins, cross joins and self-joins!
SQL Server - create databases, tables and relationships
Posted by Andy Brown on 19 November 2012
A guide to how to create databases in SQL Server Management Studio, including creating tables, indexing columns and using database diagrams to create relationships between tables.
Setting SQL criteria using the WHERE clause
Posted by Andy Brown on 08 November 2012
If you don't want to see a full set of records from a table in SQL, you can use a WHERE statement to filter out unwanted rows, as shown in this blog.
Using SELECT INTO and INSERT to insert SQL rows
Posted by Andy Brown on 12 October 2012
There are various ways to insert data into new or existing tables in T-SQL - this blog gives examples of each.
Using T-SQL to create tables programmatically
Posted by Andy Brown on 05 October 2012
SQL doesn’t just select data; you can also use it to create tables and link them together with relationships. This blog shows you how!
T-SQL data types - int, float, decimal, varchar, etc.
Posted by Andy Brown on 05 October 2012
Whether you're creating tables in SQL Server, using SQL variables or passing parameters to stored procedures, you'll need to understand what the possible data types that you can use are.
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!
Using ORDER BY to Sort in SQL Server Queries
Posted by Andrew Gould on 23 July 2012
If your SQL queries return lots of records you'll probably want to sort the results in some kind of order. This blog teaches you how to use the ORDER BY clause to do exactly that!
Posted by Andrew Gould on 23 July 2012
This blog teaches the absolute basics of writing queries in Microsoft SQL Server Management Studio. You'll learn how to use the SELECT and FROM keywords to create simple queries showing all of the records from a single table.
Posted by David Wakefield on 02 July 2012
Dynamic SQL should only be used as a last resort. This article gives you a tip for avoiding the use of dynamic SQL in WHERE clauses
Link SQL Views to MS Access using VBA
Posted by David Wakefield on 26 June 2012
How to link SQL Views and Tables to MS Access using VBA without getting the annoying Unique Record Identifier pop up.
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!
New in SQL 2012 - code snippets and surrounding code
Posted by Andy Brown on 15 May 2012
In a previous blog on new features of SQL 2012, I missed out the ability to insert code snippets, and also to embed or surround code in an IF, BEGIN or WHILE block. This blog rectifies this!
New features for SQL within SQL Server 2012
Posted by Andy Brown on 08 May 2012
SQL 2012 has 14 new functions, a new FileTable construct and new ways to sequence and fetch records - as this blog explains.