PARSENAME and Input Length
-
Comments posted to this topic are about the item PARSENAME and Input Length
-
Worth noting that the same 128 char limitation also applies to the QUOTENAME function.
https://docs.microsoft.com/en-us/sql/t-sql/functions/quotename-transact-sql?view=sql-server-ver15
--------------------
Colt 45 - the original point and click interface
-
Doesn't this work only provided that the delimiter is a period?
LinkedIn: http://www.linkedin.com/in/sqlrv
Twitter: http://www.twitter.com/sqlrv
Website: http://sqlrv.com -
should have gone with my gut instinct. But, I see some potential for the function in a couple of places, so will go look it up.
Thanks!
- Aaron N. Cutshall wrote:
Doesn't this work only provided that the delimiter is a period?
Yes.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) - Aaron N. Cutshall wrote:
Doesn't this work only provided that the delimiter is a period?
Yep, you are correct. Thanks for adding this!
-
Nice question, thanks Xedni
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply