Danny Ocean (4/29/2013)
Good question with important information.
I'll second that... then again my standards are to do any and all declares at the beginning of my SQL Batches/Stored Procs/Functions so I've never run into this... but it is good to know.