Dev Evening Talk – LINQ to SQL in the real world

If you’re reading this then presumably you were at the DevEvening, so hopefully you found my talk interesting or useful.

Here are the slides used which include a lot of useful links to LINQ related sites, tools etc. I’ve also blogged about some of the issue in more detail here.

Download slides from presentation

Advertisements

SQL varchar ‘bug’

I was having a hard time figuring out why my T-SQL query wasn’t working.

DECLARE @billid int, @cli varchar;
SET @billid =12345;
SET @cli = ‘02077778888’;

SELECT COUNT(*) FROM Records WHERE BillID = @billid AND CLI = @cli;

This query consistently returned a result of zero records, despite my knowing that records existed for this combination, e.g.:

SELECT COUNT(*) FROM Records WHERE BillID = 12345
AND CLI = ‘02077778888’;

would return the correct number.

Solution:

The length of the varchar had not been specified. Although it parses correctly it doesn’t actually work without a length being specified. This simple change fixed things:

DECLARE @billid int, @cli varchar(14);