Using QUOTENAME

Kenneth Fisher describes what QUOTENAME is and why you might want to use it:

Basically, it escapes any occurrence of the second parameter within the first parameter. So when would we be using it in dynamic SQL? Well, probably the most common way I’ve used it is when I’m building a list of commands I want to run.

Click through for more details, including valid quote characters.

Related Posts

Built-In SQL Server Functions

Tywan Terrell has a listing of various functions built into SQL Server: SQL Server starting with 2012 ship with a robust set of functions that can be used to make code perform faster, with fewer lines of code. The functions  can be used in ETL Process to provide better error handling. A example of this […]

Read More

Fisher’s Exact Test

Mala Mahadevan explains Fisher’s Exact Test and provides examples in T-SQL and R: The decision rule in two sample tests of hypothesis depends on three factors : 1 Whether the test is upper, lower or two tailed (meaning the comparison is greater, lesser or both sides of gender and speaker count) 2 The level of […]

Read More

Leave a Reply

Your email address will not be published. Required fields are marked *

Categories

May 2017
MTWTFSS
« Apr  
1234567
891011121314
15161718192021
22232425262728
293031