SQL to Code

Generate legacy VB/C# concatenation code from a SQL query

SQL query

Language

Variable name

Parameter prefix

Quote string values

Every line uses `&=`. The first line initialises the variable to an empty string.

Generated code

q = ""
q &= "SELECT CANCEL_FLAG FROM TMS_DO_HDR WITH (NOLOCK) "
q &= "WHERE CANCEL_FLAG = '" & _cancelType & "' "
q &= "AND AMEND_NO = 251"

Parameters (1)

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