Eirikur Eiriksson (5/15/2016)

---

Lynn Pettis (5/13/2016)

---

Could some someone provide me with some UNICODE string data that casts wrong from NVARCHAR to VARCHAR and back? Don't need a lot, just a...

Eirikur Eiriksson (5/15/2016)

---

Piling on on the CHAR(0), here are some of my favorites:

😎

SET NOCOUNT ON;

DECLARE @STR_WITH_ZERO_CHAR VARCHAR(20) = '123456789' + CHAR(0) + '1234567890';

-- CHARINDEX will not return the position of...

To further Jeff's point about the possible "unexpected" behavior of ASCII character 0, another reason to not use it unless you have a specific need for it is that it...

Lynn Pettis (5/15/2016)

---

Solomon Rutzky (5/14/2016)

---

Lynn Pettis (5/13/2016)

---

Jacob Wilkins (5/13/2016)

---

Lynn Pettis (5/13/2016)

---

Could some someone provide me with some UNICODE string data that casts wrong from NVARCHAR to VARCHAR and back? ...

Lynn Pettis (5/13/2016)

---

Jacob Wilkins (5/13/2016)

---

Lynn Pettis (5/13/2016)

---

Could some someone provide me with some UNICODE string data that casts wrong from NVARCHAR to VARCHAR and back? Don't need a lot,...

Jeff Moden (4/29/2016)

---

Nah... the question isn't off topic although I'll certainly agree that it's a sub-topic.

If a shop forbids VB, it seems to me that they wouldn't allow it to...

Most likely an issue...

David.Poole (5/1/2016)

---

I'd be curious to know which ports and protocols have to be open in the firewall to allow SQL Server to use web services.

You transmit on a port relevant...

David.Poole (4/30/2016)

---

In terms of SQLCLR calling a web service. Possible but why would you? I have seen the results when a decree from the padded cell of the...

Just FYI, there is an oddly similar thread on the MSDN forums ;-):

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/957a5b94-c7d0-49d8-928d-7cccff14b0c6/clr-aggregate-performs-an-expensive-sort

It does not seem as though there is a fix as I tested with SQL Server 2014 and...

Solomon Rutzky (4/29/2016)

---

Jeff Moden (4/28/2016)

---

So the following quote was incorrect or correct?

Hence [font="Arial Black"]this library exists because Visual Basic includes this functionality[/font], but its usage is not restricted to VB...

Chad Crawford (4/29/2016)

---

Solomon Rutzky (4/29/2016)

---

TomThomson (4/28/2016)

---

Jeff Moden (4/28/2016)

---

Grant Fritchey (4/28/2016)

---

Technical question:

I want to export large amounts of data. However, I don't want to use SSIS. I'm going to use...

TomThomson (4/28/2016)

---

Jeff Moden (4/28/2016)

---

Grant Fritchey (4/28/2016)

---

Technical question:

I want to export large amounts of data. However, I don't want to use SSIS. I'm going to use SQLCMD.EXE. I need to be...

That quote...

Jeff Moden (4/26/2016)

---

Solomon Rutzky (4/25/2016)

---

Disagree with what, exactly? You started this whole sub-topic of "Tower of Babel" because you mistakenly thought that Sachin was introducing both VB and C#. Since...