BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
Wise Owl blogs written in 2012 (page 1 of 5)
Showing blogs 1-20 (out of 100)
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.
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!
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!
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").
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!
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.
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.
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.
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!
Posted by Michael Allsop on 23 October 2012
Up, down, ceiling, floor or multiples… and you thought rounding numbers was simple!
Online training on user controls in ASP.NET
Posted by Andy Brown on 17 October 2012
User controls are the key to using ASP.NET effectively - this blog explains how and why to create and use user controls, with code examples for VB and C#.
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#.
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.
ASP.NET session variables, cookies, query string parameters, etc.
Posted by Andy Brown on 16 October 2012
There is a range of techniques for remembering information in ASP.NET across pages and even sessions, including session variables, cookies, query string parameters and crosspage postback. This blog explains how to use each of these techniques, together with the pros and cons of each.
Using ViewState to remember form values in ASP.NET
Posted by Andy Brown on 16 October 2012
When you submit an ASP.NET form, how can you remember what was on it? Answer: using the ViewState bag.
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.
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!
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.
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.
IE compatibility view stops embedded videos running
Posted by Andy Brown on 01 October 2012
If you're trying to run a YouTube video within a website and nothing happens, maybe you're using compatibility view in Internet Explorer?