ZeroFusion (5/25/2010)

---

Suppose you have a Czech_CI_AS collation set up as your DB / table collation. Then you do this:

create table #t (string varchar (5))

insert into #t (string) values ('ACH')

insert into...

tommyh (5/25/2010)

---

Out of curiousity. If one would like to get all strings containing a C from the below code... how would you do that in that collation?

create table #t (string...

Hugo Kornelis (5/25/2010)

---

malleswarareddy_m (5/24/2010)

---

hi ,

like operator will search for _ only.and return any characters. then it does not return any rows.because i worked many times using like operator.but if we...

Yes, the question was in Collations category 😛

tommyh (5/25/2010)

---

Nice question.

Taught me once again that Microsoft has some serious dope available. Doing some semiunicode shit into a normal varchar... damn.

Even more funny. Doing a Len on...

bkubicek (5/24/2010)

---

Hugo,

To do what you suggest would cause this Question to be too easy. Perhaps you are fortunate enough to NOT have inherited some poor code from previous employees....

I guessed right. Great aid for me was the gaps between neumbers. If the row of numbers was complete...

It can be some error during copy-paste. I had no problem. Where have you copied the...

Toreador (5/21/2010)

---

Not quite the same, but I've now done exactly the above and get the same error.

Note - the error appears in a popup window. I've a feeling that depending...

Oleg Netchaev (5/20/2010)

---

Because they cannot, you can ask Steve to edit one of...

Hugo Kornelis (5/20/2010)

---

natalie.ignatieva (5/20/2010)

---

The correct answer is "XML segment, with the integrated parser marking most values illegal, but IE can open this segment surrounded by root element ", but my...

malleswarareddy_m (5/20/2010)

---

Thanks for reply.I know that there are different types out put for xml.

Includes For Xml 1)path 2)auto 3)raw 4)explicit.

But when i saved this output and opened with IE it...

Hugo Kornelis (5/20/2010)

---

honza.mf (5/20/2010)

---

Hugo Kornelis (5/20/2010)

---

@honza.mf: Great question! I never work with XML myself so this was a good learning opportunity.

The only thing I like less about the question was...

Toreador (5/20/2010)

---

I ran the script and got an error

Error Character '', hexadecimal value 0x0 is illegal in XML documents.

ie the first option, which is not the correct answer.

As well as...

Hugo Kornelis (5/20/2010)

---

@honza.mf: Great question! I never work with XML myself so this was a good learning opportunity.

The only thing I like less about the question was that it also...