T-SQL functions to convert Strings to Tables
These were in a solution and I thought I'd note them on my site so I can refer to them more easily. How?
Knowledge base / Since 1999
Transact-SQL Tutorials & Guides
Practical Transact-SQL tutorials, troubleshooting notes and implementation guides from real projects.
Advanced search22 entries / Transact-SQL
Clear filters
Convert to Proper Case in T-SQL
So this is an article exploring how to convert UPPERCASE text into mixed case. The feed is originally for a personnel feed so it won't be converting long paragraphs of English text. Instead it will be applied to names and addresses as well as job titles and departments.
T-SQL: Parse an XML value
This took me a while to find so I've posted an article below detailing how to parse or extract values from a string containing XML code.
Compare two databases using T-SQL
A quick article on how to compare two Microsoft databases using the tools provided with SQL Server and without having to download any third-party products.
Split a row into multiple rows based on a column value
This is a quick article on how to split a single row into multipe rows based on the value of a column in the same table.
T-SQL concatenate an incremental row number
This is a quick article on how to use a counter added to the end of a field column of data. Eh. What? Assume the following two tables exist:
T-SQL Conversion failed when converting the varchar to data type int
A very quick note in case I forget this one. If you are trying to join two tables and receiving the error "Conversion failed when converting the varchar value 'B110' to data type int" then read on. How?
CharIndex Reverse - find occurrence starting from end of string in TSQL
This is a quick note on finding the last occurrence of a string in a longer string. This has to be in Transact SQL for a SQL Server instance only and not filtered by other code.
DataScramble - Randomizing data rows
Along with my DataJumble function and DataTumble procedure which also help scramble database tables sent to suppliers/developers, this is a function which simply finds random characters and inserts these. I would recommend using the DataTumble script over this one as this leaves data very difficult to work with: Before...
Loading more notes...
No more notes to load.