SQL code snippets and examples.
I ran across a question on StackOverflow, I did not understand the full scope of the question; however, I added my answer. We run into situations when migrating data when there is a table that […]
In .Net we are familiar with Try/Catch blocks and you can do this in SQL Server running SQL transactions as well with the additional benefit of “undoing” what was started if something were to fail […]
Every so often I need to test something with remote device processing, today happens to be one of those times. I could print some barcodes, scan them, and then process the device. Here is another […]
I needed to replicate a character 24 times in one instance and in another I had to prefix a value with leading zeros (total of 24 characters). SQL Server has a REPLICATE function that makes […]
After copying a database the ASP.Net Membership permissions might not be set for the user you are trying to connect to resulting in the error: The EXECUTE permission was denied on the object ‘aspnet_CheckSchemaVersion’, database […]
I have a string value in a column in my table. It’s a full path and filename for a .tif image. I needed to get just the filename as a column. I couldn’t use a […]
I recently needed a lookup table of all 50 US states (and Washington DC) and the provinces / territories in Canada. The script below will create a table (tbl_LUState) and will populate the table with […]
At times we copy a SQL Server database from one database name to another for testing or development. One thing that doesn’t change is the logical name: Using the following SQL script the logical name […]
I found an example that used syntax where I could find the average based on a group count. In this case, the group by is the folder’s tracking id (ParentTracking_ID) assigned to the document. SELECT […]
