fukalotiseryu
New Member
When trying to execute store procedure in sql server from c++ i am getting ce = {DB_E_ERRORSINCOMMAND}c++ code is\[code\]pCom->Execute(NULL,NULL,adCmdStoredProc);\[/code\]executing from command object..store procedure look like this \[code\]create PROCEDURE [dbo].[InsertTicketDetails]ASBEGINDECLARE @inputXml XML;SET NOCOUNT ONset @inputXml = '<Record><studentid>143</studentid></Record>';INSERT INTO dbo.sample (studentid) SELECT @inputXml.value( 'studentid[1]', 'int' ) AS studentid FROM @inputXml.nodes('/Record') a(y)END\[/code\]here inserstion is done with xml, if insertion done without xml working properly. i think it problem with xml or we cant access the xml functionality of sql server from c++?