i have got an error when i execute an internal representation of the XML document.

[Sureshrajiv]

Declare @xmlDoc nvarchar(100)
Declare @handle int
SET @xmlDoc = N'
<students>
<StudentID> 100-252-1658</StudentID>
<StudentFName>S uresh</StudentFName>
<StudentLName>P rabhu</StudentLName>
</students>'

EXEC sp_xml_prepared ocument @handle OUTPUT, @xmlDoc

If i execute bold statement i am getting an error called
Msg 137, Level 15, State 2, Line 1
Must declare the scalar variable "@idoc".

[Sureshrajiv]

jhkljhlgvkghccd fhdfbhdfhghfdfh dfgsdfgdfgdfgdf gdfgdfgdf

[deepuv04]

try the following

create procedure xmlread
 @xmlDoc text = ''
as
begin
	 --nvarchar(100)
	Declare @handle int
	SET @xmlDoc = N'
	<students>
	<StudentID> 100-252-1658</StudentID>
	<StudentFName>Suresh</StudentFName>
	<StudentLName>Prabhu</StudentLName>
	</students>'

	EXEC sp_xml_preparedocument @handle OUTPUT, @xmlDoc

	SELECT  *
	FROM	OpenXML(@handle,'students', 1)    
			WITH (StudentID varchar(50) 'StudentID[1]',
				  StudentFName varchar(50) 'StudentFName[1]',
				  StudentLName varchar(100) 'StudentLName[1]') 
end