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
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Get data from XML file

Author  Topic 

cruxmagi
Starting Member

38 Posts

Posted - 2008-11-21 : 03:23:44
Having the path of the xml file will i able to get the data into a table.
Thanks in advance

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-11-21 : 04:06:41
See http://weblogs.sqlteam.com/peterl/archive/2007/09/26/Insert-binary-data-like-images-into-SQL-Server-without-front-end.aspx



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-11-21 : 04:15:20
see this too

http://msdn.microsoft.com/en-us/library/ms191184(SQL.90).aspx
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-11-21 : 04:23:33
That link also shows how to use OPENROWSET with BULK option.



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page
   

- Advertisement -