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.
| Author |
Topic |
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
 Posted - 2008-05-21 : 15:23:04
|
| Greetings,For our user app, I was thinking of creating a format file that will be referred in the INSERT INTO OPENROWSET syntax. I do not want to put the format file on the file server where the user might accidentally delete it. So I was thinking of creating the FORMATFILE as an xml document and "embbed" it into an xml type field of a system table? Is that possible or am I stretching it here. Then when I do my INSERT INTO .....OPENROWSET command I will refer to that xml document in the xml type field which I can maybe create as a @xmldoc and feed it to my INSERT INTO command?Thanks! |
|
|
|
|
|
Format file for OPENROWSET as XML