Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
firegeek
Starting Member
5 Posts |
 Posted - 2011-05-06 : 10:37:00
|
| Hey Everybody,I'm a newbie here so I hope I'm posting in the correct forum.I am using SSMS 2008 to query a SQL Server 2005 db. I would like to use the new MERGE statement (new feature with SQL Server 2008 I think)...is this even possible or will it only work with a SQL Server 2008 db?Thanks for any input!-jeremiah |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2011-05-06 : 10:47:11
|
| Yeah it will work with only SQL Server 2008 and above versions. You cann't use it by just using SQL Server Management Studio 2008--------------------------http://connectsql.blogspot.com/ |
 |
|
|
firegeek
Starting Member
5 Posts |
Posted - 2011-05-06 : 10:50:35
|
| That's what I suspected. Thank you for the prompt reply!I will post a new thread inquiring how to execute the same sort of query using 2005 compatible statements.Thanks again! |
|
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2011-05-06 : 10:51:43
|
| http://sqlserver-tips.blogspot.com/2006/09/mimicking-merge-statement-in-sql.html |
|
|
|
firegeek
Starting Member
5 Posts |
Posted - 2011-05-06 : 11:05:17
|
| ooooh, thanks for the link, sounds promising, i'll look into it. |
|
|
|
|
|
|
SQL Server 2005 and SSMS 2008