Scalar Variable Error

• nisha.lakhwara

  Old Hand

  Points: 330

  More actions

  June 12, 2009 at 1:38 am

  #205459

  When I am creating a data in the XML document type in SQL. At the time of executing the

  sp_xml_preparedocument i am getting the error "Must declare the scalar variable @doc"

  My code is a follows:

  DECLARE @DOC int

  DECLARE @XMLDOC nvarchar(1000)

  SET @XMLDOC = N'

  OrderDate="2006-07-04T00:00:00">

  OrderDate="2006-08-16T00:00:00">

  '

  At the time of creating an internal representation of the xml document by

  "exec sp_xml_preparedocument @doc output, @xmldoc

  i am getting the error message:- Must declare the scalar variable "@doc"

  please let me know what is to be done.

• Matija Lah

  SSCertifiable

  Points: 6429

  More actions

  July 10, 2009 at 1:55 am

  #1022878

  Is the default collation of your database (or instance) case-sensitive?

  With case-sensitive collations "@DOC" "@doc".

  ML

  ---
  Matija Lah, SQL Server MVP
  http://milambda.blogspot.com