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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Do row constructors work in SSMS 2005 when...

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

Rate Topic

Display Mode

Topic Options

Author

Message

peter 82125

Posted Thursday, August 16, 2012 3:15 PM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 5:30 PM
Points: 37, Visits: 73

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

Suresh B.

Posted Thursday, August 16, 2012 11:17 PM

Ten Centuries

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 5:59 AM
Points: 1,075, Visits: 5,114

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

Post #1346333

peter 82125

Posted Friday, August 17, 2012 12:15 PM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 08, 2013 5:30 PM
Points: 37, Visits: 73

Thanks for the reply.

Post #1346700

« Prev Topic | Next Topic »

Permissions