阅读背景:

合并多个更新和插入

来源:互联网 

Basically I have a SQL Server 2008 R2 database. The database has a table called Node and Link. Link contains a StartNodeId and EndNodeId relating to a Id in Node. The database also requires a Link table between Node and Link for quicker checking of say, is this Node related to this Link or which Nodes are related to this Link. The Link table contains a Identity key, NodeId and LinkId. My problem is when I am doing my inserts I am trying to use merge statements which do not seem to be able to do what I am tryingBasically I have a SQL Server 2008 R2 database.




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: