Despite working in content management, I’ve been awful at writing. This is a short post to commit myself publicly to writing more. I’m not sure what about yet, and not all of it will be public, but I want to see what difference being rigorous about writing makes to my life.
I was trying to get a stored procedure in SQL Server to run using a mixture of parameters passed from an ASP.NET page and a local variable which I wanted to declare in order to modify one of the parameters received.
I couldn’t figure out where to put the local variable in relation to the parameters, until I found this page:
The parameters go before the ‘AS’ statement, the local variable after, but before the ‘BEGIN’ statement if you use it.