SQL Server Performance

'Adhoc' Querries

Discussion in 'Performance Tuning for SQL Server Replication' started by joe_sql, Jun 7, 2006.

  1. joe_sql New Member

    Hi

    Can someone explane ; what is Adhoc Querries ?

    Thanks and Regards
    Joe
  2. merrillaldrich New Member

    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.
  3. Madhivanan Moderator

    eg OpenRowset. Also do a google search

    Madhivanan

    Failing to plan is Planning to fail

Share This Page