- Code: Select all
CREATE PROCEDURE dbo.EncapsulatedProcedure AS
DECLARE @actno VARCHAR(19)
SET @actno = '1234'
WHERE AccountNo = @actno
As you can see, a variable is declared, set and used, but stays a local variable. I've tried this on a number of different queries and the locals NEVER become params. What gives?
BTW, I've re-started SSMS 2005 and the results are the same.