Help me with this SELECT FROM OPENXML - XML SOAP

You must assign value to @t variable before sp_xml_preparedocument
call.

On Jul 16, 1:04 pm, Sagar <anandsa...> wrote:
> The following script doesnt return any records. Why ?
>
> ---------------------------------------------------------
> declare @t varchar(1000)
> DECLARE @XMLDocPointer1 INT
>
> EXEC sp_xml_preparedocument @XMLDocPointer1 OUTPUT, @t
>
> set @t = '<EMP><EE EID=''1'' NAME=''ANAND'' /><EE EID=''2''
> NAME=''SAGAR'' /></EMP>'
> select @t
> BEGIN TRANSACTION
> select * FROM
> OPENXML(@XMLDocPointer1,'/EMP/EE')
> WITH (EID VARCHAR(2), ENAME VARCHAR(30))
>
> EXEC sp_xml_removedocument @XMLDocPointer1
> COMMIT
>
> ---------------------------------------------------------

Hello gapokrif,

Well spotted


Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons


> You must assign value to @t variable before sp_xml_preparedocument
> call.
>
> On Jul 16, 1:04 pm, Sagar <anandsa...> wrote:
>
>> The following script doesnt return any records. Why ?
>>
>> ---------------------------------------------------------
>> declare @t varchar(1000)
>> DECLARE @XMLDocPointer1 INT
>> EXEC sp_xml_preparedocument @XMLDocPointer1 OUTPUT, @t
>>
>> set @t = '<EMP><EE EID=''1'' NAME=''ANAND'' /><EE EID=''2''
>> NAME=''SAGAR'' /></EMP>'
>> select @t
>> BEGIN TRANSACTION
>> select * FROM
>> OPENXML(@XMLDocPointer1,'/EMP/EE')
>> WITH (EID VARCHAR(2), ENAME VARCHAR(30))
>> EXEC sp_xml_removedocument @XMLDocPointer1
>> COMMIT
>> ---------------------------------------------------------
>>