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
Watermark using placeholder HTML 5
< input type ="text" placeholder ="Enter watermark text" name ="txt" /> < script ty...
Send Mail via Gmail account
Add these two namespaces at the top of the page first. using System.Net.Mail; using System.Net; Then add the below function on your...
Render Section in MVC3
Define in page: @ RenderSection( "ValidationRules " , true ) @ if (IsSectionDefined( "ValidationRules" )) { @sectio...
Insert multiple rows at once in SQL Server
INSERT INTO lsItemLink ( ItemID , ownerID , Item2ID ) SELECT @ItemID , @OwnerID , TopicList . value ( '.[1]' , 'in...
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