January 16, 2009 at 3:18 am
Can anyone confirm that the new 2005 syntax additions i.e pivot etc. are also available in the 2005 SQL Server Management Studio Express.
It's just I've tried a few pivot examples which haven't worked and the PIVOT keyword hasn't been coloured as I'd expect (just stayed black like a tbl name or alias etc.), which made me think it wasn't recognised as a command.
Many thanks,
Jason
January 16, 2009 at 4:17 am
PIVOT is supported by all editions.
Check out the below link that gives a mapping of varous features to various editions:
http://msdn.microsoft.com/en-us/library/ms143761(SQL.90).aspx
-Vikas Bindra
January 16, 2009 at 4:21 am
Actually, PIVOT is available in all editions..., check BOL for comparisons of edition...
Which examples have you tried? What error do you get when executing those samples?
Does the database compatibility is set to 80?
--Ramesh
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply