September 9, 2013 at 1:17 pm
What you are seeing can drive you nuts if you have to go back and forth in compatibility. Datatypes in 2008 are available even in 2005 mode (like the table parameter, it is just a custom datatype). However, language features that were introduced in 2008 will not be available (like MERGE).
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
September 9, 2013 at 1:25 pm
Great so I am not totally crazy. I thought it was very strange that I can even fill the TVP in 2005 compatibility. It has to do with what you just said thanks.
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply