SQLServerCentral Article

ASCII Text Dump

Introduction Recently, I had the task of analyzing a varchar field for special characters. The field contained text entered by the user with a standard US keyboard; however, the proprietary software was breaking up the text and delimiting it with characters whose ASCII values were above 127. Eyeballing the text that I dumped using a […]

4.82 (11)

2021-01-15 (first published: )

7,322 reads

Blogs

Hiding Email with a Dynamic Data Masking Function–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Get SQL Server 2022 Now: It’s Called Azure

By

If you’re like me, your palms went into a cold sweat to get your...

Daily Coping 29 Nov 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Help with SQL Query

By Hogie503

Hello SQL experts, Please see attached file for table detail. I have a temp...

Retry SQLAgent Job

By MrBen

Hello. Does anyone know how I can retry a job should any one of...

Get Summary Data for Last 52 weeks by Week

By skb 44459

I have a table which stores shipment data by date. We have a need...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers