Wise Owl blogs written by Andy Brown (page 11 of 15)

Showing blogs 201-220 (out of 299)

Writing IF and ELSE conditions in SQL

Posted by Andy Brown on 29 January 2013

You can use the IF statement to test conditions in SQL - this blog explains how, and also explains why you might prefer to use CASE WHEN instead.

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

Using @@rowcount and other global variables

Posted by Andy Brown on 28 January 2013

SQL comes complete with a few useful global variables, giving you information such as the row number of the record just inserted, or the number of rows affected by a query. Here's how to use them!

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

Creating a PowerPivot calendar in Access or Excel

Posted by Andy Brown on 16 January 2013

This blog shows you how to create a calendar of dates for use in PowerPivot. Instructions are included for Excel and Access.

Tags:   Excel | PowerPivot    |    PowerPivot 2010 | Calendar

A keyboard short-cut for Word previous position

Posted by Andy Brown on 09 January 2013

A short blog explaining how to use the keyboard to cycle through previous cursor positions.

Tags:   Word | General

Create a calendar table for PowerPivot or Analysis Services in SQL Server

Posted by Andy Brown on 04 January 2013

This blog includes the SQL script to generate a table of calendar dates for linking to from within PowerPivot or an Analysis Services tabular model.

Tags:   Excel | PowerPivot    |    PowerPivot 2010 | Calendar    |    SQL Server versions | SQL Server 2012

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!

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

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

KB2716442 SQL Server 2012 Windows Update fails

Posted by Andy Brown on 02 November 2012

One idea for what to do if you continually get one Windows Update appearing when you shut down your computer.

Tags:   Musings | Random musings

Write a macro in VBA to fill in an IE form (Internet Explorer)

Posted by Andy Brown on 02 November 2012

You can use VBA to talk to Internet Explorer, providing that you understand the structure of the web page you're talking to. This blog shows how to do this!

Tags:   VBA macros | References    |    Writing VBA | VBA tutorial

Why is raising event from C# User Controls so hard?

Posted by Andy Brown on 17 October 2012

Raising events from user controls is straightforward in VB; this blog asks why it should be so much harder using C#.

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

Prevent Reporting Services from caching data

Posted by Andy Brown on 01 October 2012

By default SSRS will create files with extension .rdl.data to cache data. This blog gives two and a half ways to ensure you're always seeing the latest data in a report.

Tags:   SSRS | General
This page has 0 threads Add post