John Pollard's Technical Blog

As usual, this may well be common knowledge but I found this useful. In a stored procedure we were passing in a parameter (say @maxRows) which we wanted to use to dynamically limit the number of rows returned by the query. For ages we couldn't find a Read More...

I found the following page interesting when having issues setting a value in a SqlParameter constructor. From http://msdn2.microsoft.com/en-us/library/0881fz2y.aspx : When you specify an Object in the value parameter, the SqlDbType is inferred from the Read More...