SQL SERVER – UDF – Pad Ride Side of Number with 0 – Fixed Width Number Display. Let us learn more about this blog.
NULLIF Text: Collation Decides Whether Values Match
NULLIF text comparisons can remove a matching value. Select the matching rule explicitly and preserve the first expression’s return contract.
SQL SERVER – Pad Right Side of Number with 0 – Fixed Width Number Display
A reader needed a fixed width number display, like 1 shown as 0000001. SQL Server has no ready-made function, but a simple string trick does it.
When SSMS and Your Application Return Different Results
Investigate SSMS different results by comparing connections, parameters, session options, transactions, and plans against the application.
Reviewing a Table Change Script Before It Locks Production
Review a table change script for schema locks, data rewrites, supported online options, backfill batches, and a tested rollback.
SQL SERVER – List All Server Wide Configurations Values
I forgot the syntax to check the two digit year cutoff, so I listed all Server Wide Configurations with sys.configurations. A small script worth saving.
SQL SERVER – Simple Example of Creating XML File Using T-SQL
I always want to learn SQL Server and XML file. Let us go over a very simple example, today about how to create XML using SQL Server.