Jr. Developer asked me other day how to escape single quote?
User can escape single quote using two single quotes (NOT double quote).
SQL SERVER – Introduction to Aggregate Functions
What are Aggregate Functions in SQL Server? The Books Online definition, the full list, and the NULL and GROUP BY rules that candidates often miss.
SQL SERVER – Export Data From SQL Server to Microsoft Excel Datasheet
How to export data from SQL Server to Microsoft Excel? Enable Ad Hoc Distributed Queries, create the Excel file, and run a short query to fill it.
SQL SERVER – Download Frequently Asked Generic Interview Questions
Readers wanted more on Frequently Asked Generic Interview Questions, so the list is now a download. There is no right answer, just answer what feels right.
SQL SERVER – Most Frequently Asked Generic Interview Questions
A list of the most frequently asked generic interview questions, from why you left your last job to what co-workers say about you. Think through your answers.
SQL SERVER – TempDB Restrictions – Temp Database Restrictions
What are the TempDB restrictions? A candidate in my interview could not answer. Here is the list, from adding filegroups to backup, restore and more.
SQL SERVER – Do Not Store Images in Database – Store Location of Images (URL)
Should you store images in database tables? My advice: keep the image location (URL) in a VARCHAR column instead, so the database stays small and updates stay simple.