SQL Server CONVERT() Function
Convert data types in SQL Server with CONVERT styles for dates, strings, and binary representations.
Continue ReadingTag: SQL Server
SQL Server Handle Transaction and Try Catch
Wrap SQL Server operations in TRY/CATCH with explicit transactions for atomic commits and rollbacks.
Continue ReadingStore historical records in a history table in SQL Server
Audit data changes in SQL Server with history tables triggered on UPDATE and DELETE from base tables.
Continue ReadingSQL Snippets
Reusable SQL patterns for paging, duplicates, pivots, and date ranges across SQL Server and MySQL.
Continue ReadingClone SQL Server database
Duplicate a SQL Server database with BACKUP/RESTORE, DBCC CLONEDATABASE, or scripting for dev/test copies.
Continue ReadingSQL Server format date
Format dates in SQL Server with CONVERT, FORMAT, and style codes for locale-safe display and reporting.
Continue ReadingSQL 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 Reading