BY TOPIC▼
PROGRAMMING BLOGS▼
T-SQL BLOGS▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
Blogs from Wise Owl on Other in T-SQL
Showing blogs 1-11 (out of 11)
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.
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.
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.
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.
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!
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.
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!
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.
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.
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!