Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 about xml in sql server

Author  Topic 

pkuchaliya
Starting Member

49 Posts

Posted - 2008-11-19 : 07:54:51
hi to all,

Can any body help me.
is it better to store the complete xml string in database. because that xml string can be used in future

pankaj

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-11-19 : 08:10:16
as opposed to what? you'll have to give us a bit of background...

_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.1 out!
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-11-19 : 08:32:55
You can store xml in table in field of data type xml provided its well formed and you're using SQL 2005 or higher
Go to Top of Page
   

- Advertisement -