Viewing 15 posts - 181 through 195 (of 1,189 total)
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
December 17, 2018 at 8:43 am
OK, so I made some progress.
Drew - the TRY_CAST returned NULL, so for whatever reason trying to cast the varchar(max) column directly into XML returns that error you...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
December 14, 2018 at 2:58 pm
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
December 14, 2018 at 8:37 am
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
December 12, 2018 at 3:24 pm
I'll say it again, the error means EXACTLY what it says "illegal XML character." It does NOT mean that the message got truncated. It does NOT mean that it...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
December 12, 2018 at 3:06 pm
Thanks, everyone, for the feedback.
Regarding the questions/issues:
Can you please post an example that fails in the conversion?
Working on this. I will post a self-contained, runnable...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
December 12, 2018 at 12:31 pm
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
December 12, 2018 at 11:11 am
Thanks for this article. This has never happened to me, but I appreciate your explanation of what to do if it does.
-webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
December 7, 2018 at 8:16 am
Thanks for this great introductory article! I look forward to the rest of the Stairway.
Note, I learned this about the beginning question mark for XML documents:
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
December 6, 2018 at 2:07 pm
Thanks, nice question.
Btw this returns 11 (or rather, '11'):DECLARE @s VARCHAR(10) = '1'
SELECT @s += '1'
SELECT @s
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
December 4, 2018 at 8:30 am
Thanks for the question, I learned something about this wacky function.
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
November 21, 2018 at 8:20 am
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
November 15, 2018 at 11:14 am
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
November 12, 2018 at 2:55 pm
Thanks, very helpful question!
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
November 12, 2018 at 2:36 pm
Thanks for this heads-up. I've seen the tail-log option appear for me as described in the article. Luckily I did check the different dialog boxes and noticed it, so I...
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
November 6, 2018 at 6:25 am
Viewing 15 posts - 181 through 195 (of 1,189 total)