Blogs from Wise Owl on SQL Tutorial in T-SQL (page 2 of 3)

Showing blogs 21-40 (out of 41)

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.

Tags:   SQL | Views    |    T-SQL | SQL Tutorial

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!

Tags:   SQL | Grouping    |    T-SQL | SQL Tutorial

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!

Tags:   SQL | Calculations    |    T-SQL | SQL Tutorial

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

Tags:   SQL | Tables and columns    |    T-SQL | SQL Tutorial

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!

Tags:   SQL | Joins    |    T-SQL | SQL Tutorial

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.

Tags:   SQL | Tables and columns    |    T-SQL | SQL Tutorial

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.

Tags:   SQL | WHERE criteria    |    T-SQL | SQL Tutorial

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.

Tags:   SQL | Tables and columns    |    T-SQL | SQL Tutorial

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!

Tags:   SQL | Tables and columns    |    T-SQL | SQL Tutorial

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.

Tags:   SQL | Tables and columns    |    T-SQL | SQL Tutorial

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!

Tags:   SQL | Selecting data    |    T-SQL | SQL Tutorial

Basic SQL Queries

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.

Tags:   SQL | Selecting data    |    T-SQL | SQL Tutorial

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!

Tags:   SQL | Stored procedures    |    T-SQL | SQL Tutorial

Introduction to SQL Server Management Studio

Posted by Andrew Gould on 30 April 2012

Before you get into writing SQL Queries you should take some time to familiarise yourself with the application in which you'll be spending most of your time. This blog shows you the basics of SQL Server Management Studio.

Tags:   SQL | Tables and columns    |    T-SQL | SQL Tutorial

Designing databases for SQL Server and Access

Posted by Andy Brown on 23 April 2012

Designing relational databases is easy once you learn the few basic rules, and the procedure is identical whether you're using SQL Server or Access. This blog illuminates the subject!

Tags:   Access | Designing databases    |    SQL | Tables and columns    |    T-SQL | SQL Tutorial

Calculating Age in SQL with a User-Defined Function

Posted by Andrew Gould on 16 February 2012

A common requirement in SQL queries is calculating a person's age. The expression you need to do this accurately is relatively long, so why not replace it with a user-defined function? This blog shows you how!

Tags:   SQL | Calculations    |    SQL | Functions    |    T-SQL | SQL Tutorial

Changing Settings in SQL Server Management Studio

Posted by Andrew Gould on 16 February 2012

If you've spent time in the SQL Server Management Studio application you'll probably have noticed that it's not the most user-friendly environment for writing SQL queries. This blog explains how to change a few settings to make your query writing just a little easier.

Tags:   SQL | SQL programming    |    T-SQL | SQL Tutorial

Free SQL training

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.

Tags:   SQL | Selecting data    |    SQL | WHERE criteria    |    SQL | Calculations    |    SQL | Joins    |    SQL | Grouping    |    SQL | Stored procedures    |    SQL | Transactions    |    SQL | CTEs, subqueries    |    T-SQL | SQL Tutorial

Dates and Times in SQL Server

Posted by Andrew Gould on 13 February 2012

Dates and times can be the most frustrating data types to work with in SQL Server. Learn everything you need to know about the way dates work with this handy blog series and enjoy happier times!

Tags:   SQL | WHERE criteria    |    SQL | Calculations    |    T-SQL | SQL Tutorial

Common Table Expressions (CTEs) - SQL Training

Posted by Andy Brown on 20 October 2011

This blog gives training on writing CTEs in SQL, or Common Table Expressions to give them their full title. The blog also includes a section on creating recursive CTEs.

Tags:   SQL | CTEs, subqueries    |    T-SQL | SQL Tutorial
This page has 0 threads Add post