T-SQL – Page 2 – CodeRavo

Padding Strings with Leading Zeros in SQL Server

Padding Strings with Leading Zeros in SQL Server In many database applications, maintaining consistent data formats … Padding Strings with Leading Zeros in SQL ServerRead more

concat, data-formatting, format, isnull, leading-zeros, right, SQL Server, string manipulation, string-padding, T-SQL

Renaming Columns in SQL Server

SQL Server provides a mechanism to rename columns within a table, allowing you to modify your … Renaming Columns in SQL ServerRead more

database administration, Database Management, database schema, rename-column, sp-rename, SQL, SQL Server, T-SQL, transact-sql

Discovering Database Tables with T-SQL

Understanding Database Schemas and Table Discovery Relational databases organize data into tables, and understanding the structure … Discovering Database Tables with T-SQLRead more

database tables, INFORMATION_SCHEMA, SQL Server, sys.tables, T-SQL