Hi Guest 1 HomePage 1 Jobs 1 WalkIn 1Articles  

 :) Latest Topic
AJAX
VB.NET
SQL Query
UDDI
CLASS
JAVASCRIPT
SharePoint Interview
SilverLight
WCF
general knowledge
 ASP.NET
 :) Hot Jobs
 
 :) Latest Articles


  

 
Add a Extra node to XML column in SQL Table or extra attributes in XML column
Question Posted on 20 May 2020

Home >> DataBase >> SQL Query >> Add a Extra node to XML column in SQL Table or extra attributes in XML column




Add a Extra node to XML column in SQL Table or extra attributes in XML column
Below is the SQL Script to insert the extra node to the SQL Table Column which type is XML. First we create a tables which have one column that is XML type.


XML Data Types in SQL
From above script a new table is created with name Employee_XML now with the help of below line of script a new node will be added. New Node which is added is "Band"


XML Update


Other Important Questions
Syntax to rename a column
Query to get first day of month
replace null value to zero in sql
Update data using join
How to rename database







Hello Sir/Madam as Covid is spreading we request you to please take care your self and visit helpsthepoor.com

 
Top Searches:asp net questions vb net questions sql query uddl questions class javascript sharepoint interview questions and concept silverlight questions and concept wcf questions beans general knowledge ajax questions
PHP | Biztalk | Testing | SAP | HR |