SQL Server format date
Format dates in SQL Server with CONVERT, FORMAT, and style codes for locale-safe display and reporting.
Continue ReadingTag: Database
SQL SERVER – Remove the last character in a string
Trim the final character from strings in SQL Server with LEFT, SUBSTRING, and LEN for trailing delimiters.
Continue ReadingUsing comma separated value CSV parameter strings in SQL IN clauses
Split CSV strings into rows for SQL IN filters using STRING_SPLIT, table-valued functions, or XML tricks.
Continue ReadingSQLPlus Snippets
Handy SQL*Plus commands for scripting, formatting output, and running reports from the Oracle command line.
Continue ReadingSQL Joins
Understand INNER, LEFT, RIGHT, and FULL joins in SQL with clear examples for relational queries.
Continue Reading