|
|
Terms of Agreement:
By using this article, you agree to the following terms...
1) You may use
this article in your own programs (and may compile it into a program and distribute it in compiled format for languages that allow it) freely and with no charge.
2) You MAY NOT redistribute this article (for example to a web site) without written permission from the original author. Failure to do so is a violation of copyright laws.
3) You may link to this article from another website, but ONLY if it is not wrapped in a frame.
4) You will abide by any additional copyright restrictions which the author may have placed in the article or article's description. | create procedure dbo.up_Insert_Company(@xmldata ntext)
as
begin
declare @FileHandle int -- Filehandle to the xml stuff
/* convert the xml data into a recordset */
exec dbo.sp_xml_preparedocument @FileHandle output, @xmldata
insert into dbo.categories
select * from openxml(@FileHandle, '/record')
with dbo.categories
end
/* And here's how you execute the SQL... */
dbo.up_Insert_Company '<record CategoryName=''Sample Insert'' Description=''Testing'' />' | |
Other 1 submission(s) by this author
|
|
|
Report Bad Submission |
|
|
Your Vote! |
See Voting Log |
|
Other User Comments |
5/30/2001 12:28:54 PM:Paul Where can I find
dbo.sp_xml_preparedocument ?
|
5/30/2001 12:30:35 PM:Paul Sturgill Nevermind... :)
|
6/15/2001 5:02:53 PM:Julius I was getting a null value error.
Adding CategoryID to CategoryName and
Description did the trick...
|
|
Add Your Feedback! |
Note:Not only will your feedback be posted, but an email will be sent to the code's author in your name.
NOTICE: The author of this article has been kind enough to share it with you. If you have a criticism, please state it politely or it will be deleted.
For feedback not related to this particular article, please click here. |
|