Link to home
Create AccountLog in
Avatar of kowsika devi
kowsika devi

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.
Avatar of Pawan Kumar
Pawan Kumar
Flag of India image

Link to home
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of kowsika devi
kowsika devi


thanks jj :-)
thanks jj
Avatar of Nitin Sontakke
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!