Programming blogs from Wise Owl (page 4 of 7)

Showing blogs 61-80 (out of 133)

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

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

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

SSRS custom assemblies using C# or VB

Posted by Andy Brown on 03 August 2012

Reporting Services allows you to write functions in C# or Visual Basic, then reference these as custom assemblies. This blog shows how - and why - you might do this.

Tags:   SSRS | Custom code    |    Visual Basic | SSRS    |    Visual C# | SSRS

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

How to embed and call VB functions within a Reporting Services report

Posted by Andy Brown on 13 July 2012

SQL Server Reporting Services allows you to write (and use) custom functions written in Visual Basic within a report. This blog considers the pros and cons, and shows how to do this.

Tags:   SSRS | Custom code    |    Visual Basic | SSRS    |    Visual C# | SSRS

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

Using Excel VBA to Label Multiple Series in a Chart

Posted by Andrew Gould on 30 May 2012

This follow-up article to a previous blog describes how to label the data points in multiple series in Excel using VBA.

Tags:   Writing VBA | Other    |    VBA macros | Working with charts

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
This page has 0 threads Add post