How to convert numbers to roman numerals in SQL Server November 21th, 2015 0 Database Query Development Data Formatting and Validation SQL Server
How to convert milliseconds, seconds, or minutes to TIME in SQL Server November 18th, 2015 4 Database Query Development Data Formatting and Validation SQL Server
How to calculate business days in SQL Server (dCalendar table) 29 July 2015 9 Database Data Formatting and Validation SQL Server
How to create a table of holidays (national, state, and mobile) in SQL Server 28 July 2015 10 Database Data Formatting and Validation SQL Server
How to remove accent and special characters from a string in SQL Server 27 July 2015 1 Database C # (CSharp) CLR Query Development Data Formatting and Validation SQL Server
How to use JSON in SQL Server 2008, 2012 and 2014 - Reading JSON strings, importing to the bank and exporting to XML 25 July 2015 3 Database Query Development Data Formatting and Validation Little Known Features Hacks Integrations JSON, XML, CSV and Excel SQL Server
How to export data from a SQL Server table to HTML 12 July 2015 7 Database Query Development Data Formatting and Validation Integrations SQL Server
How to validate state registration using T-SQL function in SQL Server 18 May 2015 2 Database Query Development Data Formatting and Validation SQL Server
How to convert the run_date and run_time columns from job_history to datetime in SQL Server 7 May 2015 1 Database DMVs and Catalog Views Data Formatting and Validation SQL Server SQL Server Agent
Working with cryptographic functions (MD4, MD5, SHA1, SHA2_256, and SHA2_512) using the SQL Server HASHBYTES function February 18rd, 2015 0 Database Query Development Data Formatting and Validation SQL Server