Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with a sproc using a xml input parm
I’m new to Vb.net or VB in general and need help executing a sproc with a well-formed XML input Here is the short version of it Alter procedure dob.RTC_Customer_Update ( @XMLData ntext = null, @vUser varchar(10)) as declare @nError int declare @sMode varchar(10) declare @vnName varchar(100) declare @sErrorDesc varchar(100) declare @dTodate datetime, @XMLHnd int declare @TMp table (NCUSTKEY numeric ( 6 ) , VCNTRYCODE varchar ( 2 ) , VIDTYPE varchar ( 1 ) , .. .. .. .. .. .. .. .. .. .. .. .. .. Mode int) begin transaction set nocount on if @XMLData is null begin select @nError=5 end select @dToday = getdate() EXEC sp_xml_preparedocument @XMLHnd OUTPUT, @XMLData Inset into @Tmp (NCUSTKEY , VCNTRYCODE , VIDTYPE , |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to use a cell value as a parm in a canned function? | Excel Discussion (Misc queries) | |||
Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
How do I add input data in the input ranges in drop down boxes. | Excel Discussion (Misc queries) | |||
=SUMIF(Input!H2:H718,AZ19,Input!E2:E685)AND(IF | Excel Worksheet Functions | |||
CODE to select range based on User Input or Value of Input Field | Excel Programming |