Tag Archives: sql

Returning TOP and BOTTOM Rows in SQL

The other day I saw a request come across a forum that was asking how to get the top 1 and the bottom 1 of customers with most and least …

Tags: , , , , , , , , | Posted under Programming/Coding | Leave a comment

Change Links in SQL Objects when Cloning Production to Test

Let me say at least one time in this article…..”Backup your Database before running the created text file.” Ok, now that I have said that let’s talk about a problem …

Tags: , , , , , , , , , , | Posted under Programming/Coding | Leave a comment

Comparing SQL Databases for Differences in Objects

Like the real world, development practices keep changing so when I find development code that can make my life easier I want to save it for future use. In this …

Tags: , , , , , , , , , | Posted under Programming/Coding | Leave a comment