SQL Server Performance Forum – Threads Archive
‘Adhoc’ QuerriesHi Can someone explane ; what is Adhoc Querries ? Thanks and Regards
Adhoc queries are "sent" into the database server as plain text, e.g. "Select column_a, b, c from myTable" That distinguishes them from other methods, like Stored Procedures, where the SQL statement(s) are not delivered to the server in that way.
eg OpenRowset. Also do a google search Madhivanan Failing to plan is Planning to fail