|
Comments
|
|
ok
|
|
|
ok
|
|
Kamen Angelov on
11/1/2010
Will be good to include allowed characters for second parameter (quote delimiters).
QUOTENAME recognizes [] () {} <> pairs and single delimiters ' " and `
For any other character the function returns NULL value. By example QUOTENAME('andy', '`') returns `andy` , but QUOTENAME('andy', '*'), QUOTENAME('andy', 'C') and QUOTENAME('andy', NULL) returns NULL.
|
|
|
very clear
|
|
|
Very interesting
|
|
|
Audio is a bit fuzzy
|
|
|
Good video, but somewhat worthless function
|
|
Kris Robinett on
11/1/2010
Very well explained - don't know how often I will use this funtion, but I understand it.
|
|
|
Consistently good information. Thank you, Andy.
|
|
|
Just noticed that you increased the size of the output. Thanks, Andy, for your consistently great presentations and for responding to your audience so well.
|
|
Mark Hathaway on
11/1/2010
It's nice to see the more obsure functions explained.
|
|
|
Like the font size in the results pane now. Thanks.
|
|
|
Learned something new today. There are lot of new little little tricks in 2008 and I am just getting around to learn them.
|
|
|
a good one
|
|
Peter Voutov on
11/1/2010
didn't really explain the reason why you'd use this function over straight concatenation. with the 128 character limit it seems like a function that's not very useful. i imagine it performs much faster than manual string concatenation, which would be a reason to use it in a large select statement that needed quoted columns (e.g. bulk exporting of data?)
|
|
|
I think it would have been useful to show that QuoteName also handles embedded closing characters by "doubling them up". So quotename('a]b',']') returns: [a]]b]
and quotename('a"b",'"') returns: "a""b"
|
|
GParvathesam on
11/1/2010
-
|
|
|
This was very clear and understandable.
|
|
Santosh Singh on
11/2/2010
nothing great about this function
|
|
|
ok
|
|
|
I really enjoy these short and to the point videos. I like the format of just explaining how to use one thing at a time. Over time it helps to build a solid knowledge foundation. Thanks for doing these!
|
|
|
Good explanation of a function that I have never used.
|
|
|
Thanks, it is very useful
|
|
|
I know you want these short, but you ignored the primary benefit of quotename, ie the handling of imbeded quotes
DECLARE @test VARCHAR(255)
SET @test = 'Ed''s data'
SELECT @test
select QUOTENAME(@test,'''')
SELECT '''' + @test + ''''
the last two do NOT give the same result
|
|
|
great
|