Hello:
I need to load a style sheet of XML data into a SQL server 2000 database. I am new to this because I have not loaded XML style sheets.
I needed to know what data type to use in the table for the field. I have currently defined as ntext data type.
Secondly how I load XML document in the table? File extention is .xsl.
In Oracle database we use insert statement as follows for long datatype:
DECLARE
vSTYLE_SHEET_CONTENTS LONG;
BEGIN
vSTYLE_SHEET_CONTENTS := NULL;
vSTYLE_SHEET_CONTENTS := '<style sheet contents>
INSERT INTO APPOWNER.XSL_STYLE_SHEET(STYLE_SHEET_NAME
,STYLE_SHEET_CONTENTS)
VALUES('BOClientID.xsl', vSTYLE_SHEET_CONTENTS);
Any help will be greatly appreciated.
Thank you