Deprecated: Unparenthesized `a ? b : c ? d : e` is deprecated. Use either `(a ? b : c) ? d : e` or `a ? b : (c ? d : e)` in /home/sgreimer/stevenreimer.com/includes/utilities/library.php on line 660

Deprecated: Unparenthesized `a ? b : c ? d : e` is deprecated. Use either `(a ? b : c) ? d : e` or `a ? b : (c ? d : e)` in /home/sgreimer/stevenreimer.com/includes/Page.class.php on line 574
StevenReimer.com :: Home
Ok, I know Microsoft isn't big on following laid out standards, but it doesn't stop it from causing headaches. Today I found out that a simple column rename in SQL server is not possible with standard, well documented SQL. alter table tablename change oldname newname varchar (10); Instead I have to use some sort of SQL Server procedure sp_rename sp_rename 'TableName.ColumnName', 'NewColumnName', 'COLUMN'