Blogs written in 2012
Showing blogs 1-20 (out of 100)
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.
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!
You can use SQL to do everything from simple arithmetic through to complicated functions - this blog gives you the low-down!
This short blog explains how you can create calculated formulae for fields in an SQL table (known as "computed columns").
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!
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.
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.
One idea for what to do if you continually get one Windows Update appearing when you shut down your computer.
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!
Up, down, ceiling, floor or multiples… and you thought rounding numbers was simple!
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#.
Raising events from user controls is straightforward in VB; this blog asks why it should be so much harder using C#.
This mini-blog provides a means to generate the database used by our online ASP.NET tutorial.
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.
When you submit an ASP.NET form, how can you remember what was on it? Answer: using the ViewState bag.
There are various ways to insert data into new or existing tables in T-SQL - this blog gives examples of each.
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!
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.
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.
If you're trying to run a YouTube video within a website and nothing happens, maybe you're using compatibility view in Internet Explorer?