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?
Read noteKnowledge base / Since 1999
Scripts, systems & field notes.
Practical solutions and technical notes from CRM platforms, workflow automation, APIs, databases and the systems around them.
22 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.
Read note
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.
Read note
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.
Read note
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.
Read note
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:
Read note
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?
Read note
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.
Read note
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...
Read note
Loading more notes...
All published notes loaded.