Ads 468x60px

Pages

Blogroll

Friday, May 18, 2012

Insert multiple rows at once in SQL Server


  INSERT INTO lsItemLink(ItemID,ownerID,Item2ID ) SELECT @ItemID,@OwnerID, TopicList.value('.[1]', 'int') AS TopicID      
  FROM @CommunityItemIDs.nodes('//Communities/Community') AS R(TopicList

0 comments:

Post a Comment