store SQL query in database when I use parameter
can anyone help me how I can store SQL query (statement as log) in database when I use parameter to execute a query?...
My prefer language = vb.net
for example :
sql = "insert into model (name, age, date_of_confinement,type_of_sickness, type_of_IVfluid, number_of_bottles, drop_rate)" & _
" values (@name, @age, @dateOfConfinement, @sicknessType, @fluidType, @bottleAmount, @dropRate)"
I want to store SQL with entered values, but it stores the same as above code
Thanks in advance
Posted 1 Oct '12 - 22:55