SQL Query Converter — avixiatools

Legacy C# / VB code

Language

Quoted values become named parameters. Numeric literals and helper expressions stay intact.

Helper definitions (optional)

Converted code

Q = Q & " SELECT CANCEL_FLAG FROM TMS_DO_HDR " & DB.NoLock & " "
Q = Q & " WHERE "
Q = Q & " CANCEL_FLAG = " & @cancelType & " "
Q = Q & " AND AMEND_NO = 251"
If _fltrBy = "B" Then
    Q = Q & " AND BARCODE=" & @DONo & ""
ElseIf _fltrBy = "M" Then
    Q = Q & " AND (MANUAL_DONO=" & @DONo & " OR DOC_NO=" & @DONo & ")"
End If

Parameters (2)

cmd.Parameters.AddWithValue("@cancelType", _cancelType)
cmd.Parameters.AddWithValue("@DONo", _DONo)

Rendered SQL with parameters

-- Default path
 SELECT CANCEL_FLAG FROM TMS_DO_HDR WITH (NOLOCK)  WHERE  CANCEL_FLAG = @cancelType  AND AMEND_NO = 251

-- _fltrBy = "B"
 SELECT CANCEL_FLAG FROM TMS_DO_HDR WITH (NOLOCK)  WHERE  CANCEL_FLAG = @cancelType  AND AMEND_NO = 251 AND BARCODE=@DONo

-- _fltrBy = "M"
 SELECT CANCEL_FLAG FROM TMS_DO_HDR WITH (NOLOCK)  WHERE  CANCEL_FLAG = @cancelType  AND AMEND_NO = 251 AND (MANUAL_DONO=@DONo OR DOC_NO=@DONo)