'Adhoc' Querries | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

‘Adhoc’ Querries

Hi Can someone explane ; what is Adhoc Querries ? Thanks and Regards
Joe
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
]]>