This example shows the SQL script generated by the first OpenXml call. The script creates and populates a table with the extracted depts table data. Subsequent OpenXml calls, shown in Example 8, generate similar scripts for the emps, emp_phones, and projects data.
-- output file depts.sql
create table depts_ext
(dept_id char( 4 ) null, dept_name varchar(50) null )
insert into depts_ext values('D123', 'Main')
insert into depts_ext values('D234', 'Auxiliary')
insert into depts_ext values('D345', 'Repair')
| Copyright © 2004. Sybase Inc. All rights reserved. |
|
|
