Download
100% FREE
Office Document APIs for .NET
Online: 759
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Bookmarks
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Interviews
>
Sql Server
>
Loading ...
How to Insert XML Data into Existing XML Node?
Posted by
Lakhangarg
on 9/16/2009 | Category:
Sql Server Interview questions
| Views: 5549
Post
|
Interview FAQs
|
Exclusive Questions
|
Interview Home
Answer:
declare @xml xml
set @xml = '<root/>'
select @xml
declare @value varchar(10)
set @value = 'val1'
set @xml.modify('insert <item value="{sql:variable("@value")}" /> into (/root)[1]')
select @xml
Asked In:
Many Interviews |
Alert Moderator
Bookmark It
< Previous :
Which method is used to clear an Array in javascri ...
Next > :
How we can Modify XMl Data in SQL Server 2005?
Comments or Responses
Login to post response
More Interview Questions by Lakhangarg
How we can Modify XMl Data in SQL Server 2005?
Name the method used in SQL Server to Read XML Data?
Is There any other Methods in SQL Server 2005 to Read XML Data?
try { Response.Write("Try Block:"); ...
In this Sample Code which catch block will be executed? try { i ...
Which should be used to redirect on next page in the same server?
What is the name of base class for .NET
Is it Possible to create more than one machine config file.
Latest Interview Questions
What Are Attributes in DotNet?
What is Polymorphism?
What is Event Bubbling?(Asp.net)
What type of language is the SELECT command in SQL Server?
Which of the following queries generates an error when executed? DECL ...
Can we execute any web site without the web.config file?
What's the difference between Codebehind="MyCode.aspx.cs" an ...
How do you turn off cookies for one page in your site?
More ...