Blogs from Wise Owl on Other in T-SQL

Showing blogs 1-12 (out of 12)

In SSMS, how to add multiple aliases to tables using the ALT key

Posted by Andy Brown on 23 March 2016

It's only a small thing, but … this blog shows how you can click and drag with the ALT key held down, then type to apply a table alias to lots of tables simultaneously.

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

Common Table Expressions are even better than I'd realised, as this blog shows

Posted by Andy Brown on 01 February 2016

CTEs (or Common Table Expressions) allow you to divide complicated queries up into two or more simple discrete tasks, as this blog explains.

Tags:   SQL | CTEs, subqueries    |    T-SQL | Other

A short blog listing many ways to create aliases for columns in SQL

Posted by Andy Brown on 01 February 2016

It's not often that this owl learns new things about SQL when giving a course, but when I do, I like to share my new knowledge! This blog shows a new way to create aliases for columns in SQL.

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

Pivoting Data in SQL Server

Posted by Andrew Gould on 09 June 2014

Using the Pivot operator in SQL Server allows you to create basic pivot tables from your query results. This blog teaches you how to create simple, static pivots, crosstab-style tables and exciting, dynamic pivot tables.

Tags:   SQL | Dynamic SQL    |    SQL | CTEs, subqueries    |    T-SQL | Other

Generate the database used by the ASP.NET training blog

Posted by Andy Brown on 17 October 2012

This mini-blog provides a means to generate the database used by our online ASP.NET tutorial.

Tags:   ASP.NET webforms | General    |    SQL | General    |    T-SQL | Other

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!

Tags:   SSRS | Matrices    |    SQL | Stored procedures    |    T-SQL | Other

Dynamic SQL - No, No, No!

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

Tags:   SQL | Selecting data    |    SQL | WHERE criteria    |    SQL | Dynamic SQL    |    T-SQL | Other

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

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

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 21 December 2010

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