Martin Bell UK SQL Server MVP - All Comments

VBUG Manchester March 3rd 2010 - Slides and examples

Martin Bell UK SQL Server MVP — Mon, 15 Mar 2010 22:34:19 GMT

At the VBUG meeting in Manchester on 3rd March, I was scheduled to talk about Table Valued Parameters

VBUG Manchester March 3rd 2010 - Slides and examples

Martin Bell UK SQL Server MVP — Mon, 15 Mar 2010 22:34:16 GMT

At the VBUG meeting in Manchester on 3rd March, I was scheduled to talk about Table Valued Parameters

VBUG Manchester March 3rd 2010 - Slides and examples

Martin Bell UK SQL Server MVP — Mon, 15 Mar 2010 22:34:14 GMT

At the VBUG meeting in Manchester on 3rd March, I was scheduled to talk about Table Valued Parameters

Learning SQL Server - Martin Bell UK SQL Server MVP

Learning SQL Server - Martin Bell UK SQL Server MVP — Sat, 13 Mar 2010 00:51:22 GMT

Pingback from Learning SQL Server - Martin Bell UK SQL Server MVP

Dew Drop – March 12, 2010 | Alvin Ashcraft's Morning Dew

Dew Drop – March 12, 2010 | Alvin Ashcraft's Morning Dew — Fri, 12 Mar 2010 13:45:28 GMT

Pingback from Dew Drop – March 12, 2010 | Alvin Ashcraft's Morning Dew

Daily tech links for .net and related technologies - Mar 01-03, 2010

Sanjeev Agarwal — Mon, 01 Mar 2010 06:51:56 GMT

Daily tech links for .net and related technologies - Mar 01-03, 2010 Web Development ASP.NET MVC TempData

Dew Drop – February 27, 2010 | Alvin Ashcraft's Morning Dew

Dew Drop – February 27, 2010 | Alvin Ashcraft's Morning Dew — Sat, 27 Feb 2010 19:57:51 GMT

Pingback from Dew Drop – February 27, 2010 | Alvin Ashcraft's Morning Dew

Dew Drop February 21-22, 2010 | Alvin Ashcraft's Morning Dew

Dew Drop February 21-22, 2010 | Alvin Ashcraft's Morning Dew — Mon, 22 Feb 2010 02:00:55 GMT

Pingback from Dew Drop February 21-22, 2010 | Alvin Ashcraft's Morning Dew

re: ROWCOUNT when setting variables

rmjcsltd — Thu, 11 Feb 2010 22:12:30 GMT

Hello.

A very similar source of hard-to-find problems is when a SELECT assignment matches NO rows, the variable is unchanged, rather than NULLed as is easy to expect. For example, using your num table;

declare @num int

set @num = 1

select @num = num from nums where val = 'seventy'

select @num, @@rowcount

@@rowcount is 0 and @num is 1.

However, the following DOES assign a NULL;

set @num = ( select num from nums where val = 'seventy' )

Regards,

Rhys

re: SQL Server 2008 R2 Update for Developers Training Kit Released

sqlartist — Wed, 10 Feb 2010 18:55:17 GMT

It would have been a great update if they had fixed the Reporting Services prerequistes problem. It requires the R2 Adventure Works databases - you can install them from the provided link but it still fails.

Twitter Trackbacks for SQL Server 2008 R2 Update for Developers Training Kit Released - Martin Bell UK SQL Server MVP [sqlblogcasts.com] on Topsy.com

Tue, 09 Feb 2010 11:14:25 GMT

Pingback from Twitter Trackbacks for SQL Server 2008 R2 Update for Developers Training Kit Released - Martin Bell UK SQL Server MVP [sqlblogcasts.com] on Topsy.com

February 5, 2010

ASeventhSign — Sat, 06 Feb 2010 02:09:23 GMT

February 5, 2010

re: Partitioning Existing Tables

MartinBell — Fri, 05 Feb 2010 11:37:18 GMT

I've updated this article following comments and a discussion with Dave Levy.

Dew Drop – February 4, 2010 | Alvin Ashcraft's Morning Dew

Dew Drop – February 4, 2010 | Alvin Ashcraft's Morning Dew — Thu, 04 Feb 2010 14:24:09 GMT

Pingback from Dew Drop – February 4, 2010 | Alvin Ashcraft's Morning Dew

Dew Drop – February 4, 2010 | Alvin Ashcraft's Morning Dew

Dew Drop – February 4, 2010 | Alvin Ashcraft's Morning Dew — Thu, 04 Feb 2010 14:24:09 GMT

Pingback from Dew Drop – February 4, 2010 | Alvin Ashcraft's Morning Dew