query

Question

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.

Vulpes · Answer

Why not just do: SELECT invrd_id FROM Dispatch_Master WHERE dis_id = @dis_id AND invrd_id = @invrd_id

Najim Mulla · Answer

@inverd_id is declared parameter

Michal Habalcik · Answer

well are you adding @inverd_id as a query parameter? if so I believe it won't work as it works only in conditions. try String.Format for this purpose. String.Format(SELECT {0}=invrd_id FROM Dispatch_Master where (dis_id =@dis_id) inverd_id)

Manish Kumar Choudhary · Answer

Hi Najim Mulla  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.