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.
Knowledge base / Since 1999
Databases Tutorials & Guides
Practical Databases tutorials, troubleshooting notes and implementation guides from real projects.
Advanced search75 entries / Databases
Clear filters
Delete related records from multiple tables
So this is a quick article on how to delete from multiple tables in a mySQL database where we use some JOIN statements.
Error 1065: Query was Empty
In view of the fact that this error pops up in so many systems I take over, I have often gone down the wrong path following the red herring as it were when in fact the answer to this is very common.
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...
DataTumble - Randomize Data Rows
This is a stored procedure I've nabbed from some consultants from my day job. It shuffles the records and matching data values: Before: ID Name DateOfBirth --------- ------------ ----------- 1 John Smith 1988-06-24 2 Fred Bloggs 1972-11-17 3 Another User 1964-02-18 After: ID Name DateOfBirth...
Generate Academic Calendar using MySQL
We have a specific timetabling system for academic institutions and all our staff/students follow academic week numbers as opposed to calendar week numbers.
Search a database for a value and count matching rows
We have a datawarehouse and we want to be able to count all the records in any table of the database that match on a particular warehouse load. This is a column value where the column is called "WarehouseLoadKey" and the value we want to search on is "3" (the 3rd incremental load). How? The below stored procedure can b...
Stored Procedure to List Distinct Values and Counts
Yes you could just run a SELECT DISTINCT query along with collation to make it case-sensitive and/or accent-sensitive but using this stored procedure means I only specify the table and then the columns. How?
Convert a delimited string to table
This is a quick note to show you how to convert a given comma delimited string into a database table: Given: "Title,Forenames,Surname" Return: ID Value ------ ---------------- 1 Title 2 Forenames 3 Surname Note the below example omits the ID column and just leaves VALUE.
Loading more notes...
No more notes to load.