Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Do row constructors work in SSMS 2005 when connected to 2008? Expand / Collapse
Author
Message
Posted Thursday, August 16, 2012 3:15 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, November 5, 2013 10:30 AM
Points: 44, Visits: 99
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!
Post #1346264
Posted Thursday, August 16, 2012 11:17 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 5, 2014 2:55 AM
Points: 1,101, Visits: 5,280
Yes. Lower version SSMS can be used to connect to higher version instances and execute SQL statements including any new syntax/statement.
Post #1346333
Posted Friday, August 17, 2012 12:15 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, November 5, 2013 10:30 AM
Points: 44, Visits: 99
Thanks for the reply.
Post #1346700
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse