SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 05:54 AM
| ||||
| ||||
 case sensitivity in stored procedure formal arguments 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      |
Linear Mode
