Question: what is the difference between ad hoc queries from stored procedure?
Answer: Stored procedure work as block of code so in place of adhoc query it work fast. Another thing is stored procedure give recompile option which the best part of SQL you just use this for stored procedures nothing like this in adhoc query. ... So use only procedures for any transaction.