Pages

▼
Showing posts with label Nulls. Show all posts
Showing posts with label Nulls. Show all posts
20 February 2025

💠🛠️🗒️SQL Server: Nulls [Notes]

›
Disclaimer: This is work in progress intended to consolidate information from various sources. It considers only on-premise SQL Serve...
07 January 2011

💎🏭SQL Reloaded: Pulling the Strings of SQL Server IV (Spaces, Trimming, Length and Comparisons)

›
In the previous post on concatenation , I was talking about the importance of spaces and other delimiters in making concatenations’ output m...
03 January 2011

💎SQL Reloaded: Pulling the Strings of SQL Server V (Character Indexes)

›
A string is in fact a concatenation or chain of characters, each character in the string having a position referred as character’s index . ...
14 December 2010

💎🏭SQL Reloaded: Pulling the Strings of SQL Server III: (Concatenation)

›
Typically, a database in general, and a table in particular, that follows the normalization rules, is designed to have the columns contain t...
11 December 2010

💎🏭SQL Reloaded: Pulling the Strings of SQL Server II (Creation and Selection)

›
It doesn’t make sense to talk about the creation of string data types without talking about their “selection” as people typically want to se...
07 December 2010

💎SQL Reloaded: Pulling the Strings of SQL Server I 7- Introduction

›
    The (character) string or simply the character data type , how is named by the MSDN documentation, is one of the primary data types ava...
16 March 2010

🔏MS Office: Excel for SQL Developers IV (Differences Between Two Datasets)

›
    One of the tasks which appears from time to time on my table is to determine the differences between two datasets coming from different ...
1 comment: