Skip to content

sqlsunday.com

  • About
  • Structured Concepts
    • Master data tool
    • OAuth wizard
    • Send passwords
  • Presentations
  • Downloads
  • Checklists
    • Installing SQL Server 2014
    • Installing SQL Server 2016
    • Installing SQL Server 2017
    • Installing SQL Server 2019
    • Installing SQL Server 2022
    • Conference organizer tools
    • Conference organizer checklist

Tag: char

Practical uses of binary types

The binary datatype of SQL Server is one of those features most developers don’t really use that often, but it turns out there’s more to binary values than just storing large, non-relational blobs.

Continue reading Practical uses of binary types
Published 2017-01-09
Categorized as Basics, SQL Server concepts, T-SQL Tagged ascii, binary, blob, char, conversion, convert, encoding, formatting, hex, hexadecimal, int, varbinary

A URL encoding function in T-SQL

A while ago, I needed to create a URL encoding function in T-SQL. URL encoding is what happens when you translate special characters (basically anything that isn’t an alphanumerical) so they’ll fit in a URL.

Continue reading A URL encoding function in T-SQL
Published 2013-04-07
Categorized as Intermediate, T-SQL Tagged ascii, char, encoding, hex, hexadecimal, html, http, parsing, patindex, scalar function, string, url
sqlsunday.com
Proudly powered by WordPress.