Mu query is write or wrong
SELECT @inverd_id=invrd_id FROM Dispatch_Master where (dis_id =@dis_id)
error created
Error in SELECT clause: expression near '='.
Unable to parse query text.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Najim MullaPosted Dec 20, 2014, 1:05 AM
VulpesPosted Dec 19, 2014, 9:10 AM
SELECT invrd_id FROM Dispatch_Master WHERE dis_id = @dis_id AND invrd_id = @invrd_id
Michal HabalcikPosted Dec 19, 2014, 7:25 AM
String.Format("SELECT {0}=invrd_id FROM Dispatch_Master where (dis_id =@dis_id)",
inverd_id)
Manish Kumar ChoudharyPosted Dec 19, 2014, 7:10 AM
No problem in this query it will work on sql server , only problem might be data type is mismatching check you are associating correct data type or not.