Category: SQL

Posted on: September 29, 2020 Posted by: ndconsultingllc Comments: 0

ApexSQL – Search All Database Values

ApexSQL – Search All Database Values I’ve used various stored procedures to search an entire database for a value. Recently, I found this free tool ApexSQL Search by Quest. You can easily search the entire database for a value. ApexSQL installs directly into SQL Server Management Studio. Use case: There…

READ MORE
Posted on: September 22, 2020 Posted by: ndconsultingllc Comments: 0

SQL GOTO

USE SQL’S GOTO TO BOUNCE AROUND A STORED PROCEDURE While working on a recent project, I found SQL Server’s GOTO label to skip sections of code that you don’t want to execute when various conditions have been met. In the below example from Microsoft, you see if the counter =…

READ MORE
Posted on: July 21, 2020 Posted by: ndconsultingllc Comments: 0

Splitting a String with SQL

There are times when writing a custom report, that a string is returned and you will want to bust up the string and process each value individually. With SQL Server 2016, you can simply use the built-in function “split_string”. For SQL Server databases prior to SQL Server 2016, you have…

READ MORE