Question: are sql variables case sensitive?
Answer: Even on a SQL Server instance installed with a binary collation, variable and parameter data types are case insensitive, so you can do this just fine: CREATE PROCEDURE dbo.