T-SQL – CodeRavo

Number Formatting with Commas in T-SQL

Formatting Numbers for Readability When working with large numbers in T-SQL, especially in administrative queries or … Number Formatting with Commas in T-SQLRead more

cast, commas, convert, format-function, number formatting, numeric-formatting, SQL Server, string manipulation, T-SQL

Restoring SQL Server Databases from Backup Files

Restoring a SQL Server database from a backup file is a common task that can be … Restoring SQL Server Databases from Backup FilesRead more

backup-files, compatibility-issues, database-restoration, error-messages, SQL Server, ssms, T-SQL

Conditional Logic in SQL Server

SQL Server provides several ways to implement conditional logic within queries and stored procedures. This allows … Conditional Logic in SQL ServerRead more

CASE statement, conditional logic, else-statement, exists, if-statement, iif, performance optimization, SQL Server, T-SQL, variables

Handling NULL Values in T-SQL CASE Expressions

Understanding NULL Values in SQL In SQL Server (T-SQL), NULL represents a missing or unknown value. … Handling NULL Values in T-SQL CASE ExpressionsRead more

CASE expression, COALESCE, conditional logic, handling-null-values, isnull, null, SQL Server, String Concatenation, T-SQL

T-SQL Techniques for Splitting Strings

Introduction In T-SQL, splitting strings is a common task, especially when dealing with CSV data or … T-SQL Techniques for Splitting StringsRead more

delimited-strings, sql-server-2008-r2, String splitting, T-SQL, user-defined-functions, xml-conversion

Finding Substrings Within Strings in SQL Server

Identifying Substrings in SQL Server A common task in database management is determining whether a larger … Finding Substrings Within Strings in SQL ServerRead more

CHARINDEX, database, like, pattern matching, SQL Server, string manipulation, string-search, substring, T-SQL

Identifying Installed SQL Server Instances and Their Versions on Windows

Welcome to this tutorial where we will explore methods for determining installed SQL Server instances along … Identifying Installed SQL Server Instances and Their Versions on WindowsRead more

command-line-tools, instances, registry, SQL Server, sqlcmd, sqllocaldb, T-SQL, versions, windows-management-console

Querying Data Across Linked Servers in SQL Server

Introduction SQL Server’s linked server functionality allows you to access data residing on other SQL Server … Querying Data Across Linked Servers in SQL ServerRead more

cross-server-query, database-integration, database-joins, linked-server, openquery, performance optimization, remote-query, SQL Server, T-SQL

Temporarily Disabling Foreign Key Constraints with T-SQL in SQL Server

Managing data integrity is a critical aspect of database administration, especially when dealing with foreign key … Temporarily Disabling Foreign Key Constraints with T-SQL in SQL ServerRead more

alter table, data integrity, foreign-key-constraints, nocheck, SQL Server, T-SQL, with-check-check

Replacing Newline Characters in T-SQL

Replacing newline characters in T-SQL strings can be a bit tricky due to the different ways … Replacing Newline Characters in T-SQLRead more

newline-characters, replace-function, SQL Server, string manipulation, T-SQL