Wise Owl Training - T-SQL blogs (page 3 of 3)

Showing blogs 41-56 (out of 56)

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.

Tags:   SQL | Views    |    Access | Importing and linking    |    T-SQL | Other

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

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!

Tags:   SQL | General    |    T-SQL | New features    |    SQL Server versions | SQL Server 2012

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.

Tags:   SQL | General    |    T-SQL | New features    |    SQL Server versions | SQL Server 2012

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

Scheduling Data Imports in SQL Server

Posted by Andrew Gould on 27 February 2012

If you frequently import data into a SQL Server database from the same source you'll probably be sick of going through the import wizard again and again. So why not learn how to schedule an automatic import of your data using SSIS packages and the SQL Server Agent? This blog explains how to do exactly that!

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

How to Edit all Records in a SQL Server 2008 Table

Posted by Andrew Gould on 16 February 2012

This blog explains how you can get access to all of the records in a SQL Server 2008 table when you try to edit them, rather than just the top 200.

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

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

Temporary Tables in SQL - a Training Blog

Posted by Andy Brown on 20 October 2011

If you want training in how to use temporary tables in SQL, read on! This blog shows how to create temporary tables and how to drop them safely whether or not they exist. Finally, the blog lists the pros and cons of using temporary tables in SQL.

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

Using SQL UNION queries to populate the first Item in a list type control

Posted by David Wakefield on 31 May 2011

Adding a first or default item to a list control which gets its data from a table can be tricky. This blog gives an elegant solution using UNION queries, which works equally well for ASP.NET dropdown controls, Windows Forms dropdowns or Access combo boxes.

Tags:   SQL | Selecting data    |    Access | Forms and subforms    |    ASP.NET webforms | ADO.NET and data    |    T-SQL | Other

Access project ADP file extended properties error

Posted by Andy Brown on 04 January 2011

When you try to view data for a table in an Access project with an ADP extension, Access can throw a wobbly. Here's why!

Tags:   Access | Tables and fields    |    SQL | General    |    T-SQL | Other
This page has 0 threads Add post