Timeline for Collation conflict when running dynamic sql FOR XML PATH
Current License: CC BY-SA 3.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 12, 2015 at 9:51 | comment | added | Marcello Miorelli | @Kin that's very true. it did not take long for me to figure that out... the hard way | |
| S Jun 4, 2015 at 16:48 | history | suggested | CommunityBot | CC BY-SA 3.0 |
Quoting, not code.
|
| Jun 4, 2015 at 16:24 | review | Suggested edits | |||
| S Jun 4, 2015 at 16:48 | |||||
| Jun 4, 2015 at 15:52 | comment | added | Kin Shah |
You have another problem with your Working version, make sure to have all variables same - lowercase or uppercase + MASTER.DBO. should be master.dbo .. see my answer .. as the script will fail on Binary collation servers as it is case sensitive.
|
|
| Jun 4, 2015 at 15:20 | answer | added | Kin Shah | timeline score: 5 | |
| Jun 4, 2015 at 15:18 | history | edited | Marcello Miorelli | CC BY-SA 3.0 |
added 1604 characters in body
|
| Jun 4, 2015 at 15:17 | vote | accept | Marcello Miorelli | ||
| Jun 4, 2015 at 15:11 | answer | added | tommyfly | timeline score: 3 | |
| Jun 4, 2015 at 15:01 | history | asked | Marcello Miorelli | CC BY-SA 3.0 |