employmentlawletter.com employmentlawletter.com

Labor and Employment Virtual Spring Seminar: 2021 Public Sector Legal Update

Join us as we take our annual public sector seminar virtual! During the month of May, we will host a series of CLE webinars featuring timely topics as well as updates on recent legislation and court decisions affecting public sector employers. We invite you to register for any of the complimentary webinars listed below: Brave New World: Returning to the Office in a Post-Pandemic Environment Date/Time: May 13, 2021 from 1:30 PM –...

simple-talk.com simple-talk.com

What is an ad hoc query?

Someone recently asked me which queries are ad hoc in SQL Server. An ad hoc query is a single query not included in a stored procedure and not parameterized or prepared. Depending on the server settings, SQL Server can parameterize some statements initially written as ad hoc queries. Ad hoc doesn’t mean dynamic. Here’s a simple ad hoc query example in SQL Server: SELECT LastName, FirstName FROM Person.Person; SQL Server will...