john.p.lantz (5/22/2014)
Some new functions (eg. CONCAT) work as soon as you migrate to 2012 and leave compat mode at 100. But other functions (eg. PERCENTILE_CONT) need to have compat mode at 110 in order to work.Is there a list somewhere of what new functions work simply by upgrading to SQL 2012, and what needs to have compat mode set to 110?
There's quite a bit---start with this MSDN article first, and see if your questions are answered there, as their lists here will be more complete than anything I could ever recite from memory:
http://msdn.microsoft.com/en-us/library/bb510680%28v=sql.110%29.aspx