Do row constructors work in SSMS 2005 when connected to 2008?

  • I don't have access to this setup right now, otherwise I'd just try it, but I need to know if row constructors (multiple rows in a Values clause of an Insert statement) are supported in SSMS 2005 if the database that's connected to is 2008? Thanks!

  • Yes. Lower version SSMS can be used to connect to higher version instances and execute SQL statements including any new syntax/statement.

  • Thanks for the reply.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply