List:General Discussion« Previous MessageNext Message »
From:Lev Lvovsky Date:March 1 2007 12:56am
Subject:case sensitivity in stored procedure formal arguments
View as plain text  
Could someone explain the logic of how case sensivity works on stored  
procedure formal argument names?

Example:

CREATE PROCEDURE sp_Test ( IN col1 INT,
                            IN col2 INT )
BEGIN
   INSERT INTO Table
   SET COL1 = col1,
       COL2 = col2;
END

We've found that this is problematic in some cases because of the  
case insensitivity of column names,  so I'm looking to see if there's  
a general logic for how to name formal arguments that have a similar  
name to a table column name (we ended up putting a '_' in the  
beginning of the argument name).

thanks!
-lev
Thread
case sensitivity in stored procedure formal argumentsLev Lvovsky1 Mar