skip to main
|
skip to sidebar
Web Solutions
Ads 468x60px
Pages
Home
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
Newer Post
Older Post
Home
Blog Archive
▼
2012
(5)
►
June
(1)
▼
May
(1)
Insert multiple rows at once in SQL Server
►
April
(1)
►
February
(2)
►
2011
(9)
►
December
(7)
►
November
(2)
Followers
Powered by
Blogger
.
Home
Popular Posts
Blog Archive
▼
2012
(5)
►
June
(1)
▼
May
(1)
Insert multiple rows at once in SQL Server
►
April
(1)
►
February
(2)
►
2011
(9)
►
December
(7)
►
November
(2)
About Me
Jitender
I have feelings too. I am still human. All I want is to be loved, for myself and for my talent. Working a Software Developer
View my complete profile
Blogger news
Blogger news
Blogger templates
Blogger templates
0 comments:
Post a Comment