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.
Uncategorized
SQL Server: Using Parameters and Local Variables
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:
http://www.sqlteam.com/article/introduction-to-dynamic-sql-part-2
The parameters go before the ‘AS’ statement, the local variable after, but before the ‘BEGIN’ statement if you use it.
Brighton & Hove Building Green
Website design and build for a small Brighton non-profit organisation aiming to increase awareness of the benefits of green roofs and walls. Built upon my initial experiences with HTML and CSS to produce a bigger and more complex site. Also included logo design.
