Skip to content
  • About NetTrax
  • About Us
  • Blog
  • Contact Us
  • Links
  • Media
  • Privacy Policy
  • References
  • Solutions
  • Support

NetTrax.Net

Tailored and evolving software for your unique business requirements.

  • Home
    • About NetTrax
    • About Us
  • Solutions
    • NetTrax.NET Hosted
    • NetTrax.NET Thick Client
    • NetTrax.NET Thin Client
  • Blog
    • Annoucement
    • Barcode Readers
    • Database
    • Dymo®
    • Enchancement Tracking System (ETS)
    • For Your Information
    • Programming
    • Records Management
    • Releases
    • Solution Spotlight
    • Utilities
  • Media
    • Screenshots
      • NetTrax.NET Thick Client
      • NetTrax.NET Microsoft® SharePoint® WebParts
      • NetTrax.NET Microsoft® Outlook® Add-In
  • Contact Us
    • Support
    • Privacy Policy
  • Links
    • Credits

Category: SQL Code Snippets

SQL code snippets and examples.

  • Home
  • Database
  • SQL Code Snippets
Database MS SQL Server SQL Code Snippets

Insert if missing, example of joining tables to exclude duplicates.

2020-06-18 Pete Sral

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

Read More
MS SQL Server Programming SQL Code Snippets

Example of SQL injection to step around authentication

2019-12-052020-06-14 Pete Sral

Example of SQL injection.

Read More
MS SQL Server SQL Code Snippets

SQL: Try/Catch block with rollback

2019-12-042020-06-15 Pete Sral

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

Read More
Barcode Readers Datalogic Memor™ MS SQL Server NetTrax.NET SQL Code Snippets

Creating remote device output files for testing

2015-04-032020-06-14 Pete Sral

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,

Read More
MS SQL Server SQL Code Snippets

SQL REPLICATE Function

2015-03-302020-06-14 Pete Sral

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

Read More
Database MS SQL Server Programming SQL Code Snippets

The EXECUTE permission was denied on the object ‘aspnet_CheckSchemaVersion’, database ‘<>’

2015-02-172020-06-14 Pete Sral

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:

Read More
Database MS SQL Server SQL Code Snippets

Parse a String in SQL and Return Data After Last Occurrence

2014-10-232020-06-14 Brad Arnold

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

Read More
Database MS SQL Server SQL Code Snippets

States / Provinces Lookup Table

2014-10-222020-06-14 Brad Arnold

I recently needed a lookup table of all 50 US states (and Washington DC) and the provinces / territories in Canada. The script below will

Read More
Database MS SQL Server SQL Code Snippets

Renaming a SQL Server database’s logical name

2014-07-072020-06-15 Pete Sral

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

Read More
Database MS SQL Server SQL Code Snippets

Finding the average number of documents in folders

2014-05-302020-06-15 Pete Sral

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

Read More

Posts navigation

1 2 Next

By Category

By Month Year

Recent Posts

  • 5 Ways to Spring Clean Your Security
  • Type conversion in expression CONVERT_IMPLICIT may affect “SeekPlan” in query plan choice.
  • Insert if missing, example of joining tables to exclude duplicates.
  • PDF viewer window caption
  • Datalogic Devices on Windows 10 and issues with Windows Mobile Device Center (WMDC) 6.1

Categories

  • Annoucement (2)
  • Barcode Readers (12)
  • Barcodes (1)
  • Database (28)
  • Datalogic Memor™ (10)
  • Datalogic Skorpio™ (4)
  • DLXfer (1)
  • Dymo® (1)
  • Enchancement Tracking System (ETS) (3)
  • For Your Information (6)
  • Imports (3)
  • Memor™ Collection Program (2)
  • MS Excel (1)
  • MS SQL Server (29)
  • MS Windows™ (7)
  • NetLabels (1)
  • NetTrax.NET (9)
  • Programming (12)
  • Records Management (7)
  • Releases (1)
  • SignalR (3)
  • Software (5)
  • Solution Spotlight (2)
  • Source Code Managment (1)
  • SQL Code Snippets (18)
  • SubVersion (1)
  • Utilities (6)
  • Windows Mobile Device Center (1)
All Rights Reserved 2022.
Proudly powered by WordPress | Theme: Fairy by Candid Themes.