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
Render Section in MVC3
Define in page: @ RenderSection( "ValidationRules " , true ) @ if (IsSectionDefined( "ValidationRules" )) { @sectio...
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...
Insert multiple rows at once in SQL Server
INSERT INTO lsItemLink ( ItemID , ownerID , Item2ID ) SELECT @ItemID , @OwnerID , TopicList . value ( '.[1]' , 'in...
JQuery Calender
<! DOCTYPE html > < html xmlns ="http://www.w3.org/1999/xhtml"> < head id ="Head1" runat =...
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...
Add JQuery Reference
< script type ="text/javascript" src ="http://ajax.aspnetcdn.com/ajax/jQuery/jquery-1.7.1.min.js"...
Make Mouse Busy
if ($( "#AjaxResponsetWaitingCover" ).length == 0) { var $newdiv1 = $( '<div id="AjaxResponsetWaitingCove...
Set datetime on IIS
Go into Registry Editor (start -> run -> type regedit). Get into the folder HKEY_USERS -> .DEFAULT -> International. Look fo...
Show Loading bar at the time of page loading
< script type ="text/javascript"> $(window).load( function () { show(); }); func...
Video
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq...
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