search

amachanic / sp_whoisactive

sp_whoisactive
GNU General Public License v3.0
1.14k stars 281 forks source link

Replace XML characters in l4.resource_description #60

Closed erikdarlingdata closed 2 years ago

erikdarlingdata commented 2 years ago

Closes #9

amachanic commented 2 years ago

Separately merged. Also -- please mind the pre-existing formatting style.

erikdarlingdata commented 2 years ago

@amachanic what'd I miss? I thought I had followed other nested replace calls in the proc.

amachanic commented 2 years ago

@erikdarlingdata

Every other one in the proc uses NCHAR, not CHAR, specifies the characters in reverse order of what you did, uses a COLLATE hint (which makes the expressions much faster), and has slightly different indentation. I fixed it in the final version I put together.