asked on
stored procedure how to pass parameter value in sql server 2012
Exec Igen_SP_DedupeSearch '<ROOT><Dedupe PerMobile = '+ @m_PerMobile +' /><Dedupe PerAMobile = '+ @m_PerAMobile +' /><Dedupe CorrMobile = '+ @m_CorrMobile +' />
<Dedupe CorrAMobile = '+ @m_CorrAMobile +' /></ROOT>','Custinfo'
how can i pass value @m_permobile values in xml.
<Dedupe CorrAMobile = '+ @m_CorrAMobile +' /></ROOT>','Custinfo'
how can i pass value @m_permobile values in xml.
Microsoft SQL ServerXMLSQL
Last Comment
Nitin Sontakke
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
thanks jj :-)
ASKER
thanks jj
To put it other way, you cannot pass an expression "a + b" as a parameter.
In this case, assign a + b to c and then pass c as a parameter. Hope it helps!
In this case, assign a + b to c and then pass c as a parameter. Hope it helps!