Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Stored Procedure

Status
Not open for further replies.

AnjaGrillo

Technical User
May 3, 2005
1
IT
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top