AnjaGrillo
Technical User
Hi at all,
I have the following stored procedure:
CREATE PROC INFO_BOLLETTE @tempdata text
AS
DECLARE @hDoc int
exec sp_xml_preparedocument @hDoc OUTPUT, @tempdata
INSERT INTO Bolletta SELECT * FROM OPENXML(@hDoc, 'Root/Lista')
with (Data_Fattura char (10) 'DataFattura',
Sezionale char (3) 'Sezionale',
N_Fattura char (8) 'NFattura')
EXEC sp_xml_removedocument @hDoc
GO
I want to know as he will come recalled in the XSD....
exec [INFO_BOLLETTE] @tempdata=??????
Thanks
Anja
I have the following stored procedure:
CREATE PROC INFO_BOLLETTE @tempdata text
AS
DECLARE @hDoc int
exec sp_xml_preparedocument @hDoc OUTPUT, @tempdata
INSERT INTO Bolletta SELECT * FROM OPENXML(@hDoc, 'Root/Lista')
with (Data_Fattura char (10) 'DataFattura',
Sezionale char (3) 'Sezionale',
N_Fattura char (8) 'NFattura')
EXEC sp_xml_removedocument @hDoc
GO
I want to know as he will come recalled in the XSD....
exec [INFO_BOLLETTE] @tempdata=??????
Thanks
Anja