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...
Add JQuery Reference
< script type ="text/javascript" src ="http://ajax.aspnetcdn.com/ajax/jQuery/jquery-1.7.1.min.js"...
Apply more than one watermarks on a page using single JQuery method
This post will show you an easy way to add a JQuery textbox watermark in your application. Now add below class in your project css class...
Make Mouse Busy
if ($( "#AjaxResponsetWaitingCover" ).length == 0) { var $newdiv1 = $( '<div id="AjaxResponsetWaitingCove...
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...
Video
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq...
Insert multiple rows at once in SQL Server
INSERT INTO lsItemLink ( ItemID , ownerID , Item2ID ) SELECT @ItemID , @OwnerID , TopicList . value ( '.[1]' , 'in...
Show Loading bar at the time of page loading
< script type ="text/javascript"> $(window).load( function () { show(); }); func...
Control Logout on Direct Browser close
document.onkeydown = function (e) { var evtobj = window.event ? window.event : e LastKeyPressCode = evtobj.keyCode; } $(window).unload(...
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