What is ad hoc query?

What is ad hoc query this is just a note that I have never known what is ad hoc query. Today I read "SQLSERVER Enterprise Management Platform" again, I understand what is ad hoc queries below this sentence is my personal summary: What is ad hoc queries AD-HOC: in the form of a separate SQL statement to execute the query is ad hoc queries, for example: in C # Program

What is ad hoc query this is just a note that I have never known what is ad hoc query. Today I read "SQLSERVER Enterprise Management Platform" again, I understand what is ad hoc queries below this sentence is my personal summary: What is ad hoc queries AD-HOC: in the form of a separate SQL statement to execute the query is ad hoc queries, for example: in C # Program

What is ad hoc query?

This is only a note.

I have never known what ad hoc queries and U.S. space. I read "SQLSERVER Enterprise Management Platform" again today to understand what ad hoc queries are"

The following is my personal summary:

What is ad hoc query?
AD-HOC: in the form of separate SQL statements to execute the query is ad hoc query, Hong Kong server, for example: in the C # program embedded SQL statements, or in SSMS new query window

The entered SQL code is an ad hoc query.

When SQL code is stored in a stored procedure, queries executed using stored procedures, functions, or triggers are not ad hoc queries. Ad hoc queries are performed on the spot, that is, queries are performed on the spot. Of course, this is not what code is written on the spot.

------------------------------------------- Gorgeous split line ---------------------------------------------------------

So does the ad hoc query have no execution plan cache?

In SQLSERVER enterprise-level management platform

Adhoc: Ad hoc query

Adhoc statements
A group of batch processing commands that contain select, insert, update, and delete. For such commands, only the front and back are completely consistent.
The statement contains uppercase and lowercase letters, spaces, and line breaks. The VM and SQL statements are considered to be two identical statements before the execution plan can be reused. Therefore, this requirement is quite high.

Freeproccachesys ..