Skip to content
31 Mar, 2023
Latest News
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
NetTrax.Net
  • Home
  • 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
  • Home
  • Database
  • SQL Code Snippets

Category: SQL Code Snippets

SQL code snippets and examples.

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 situations when migrating data when there is a table that […]

Leave a commentDatabase, MS SQL Server, SQL Code Snippets

Example of SQL injection to step around authentication

2019-12-052020-06-14 Pete Sral

Example of SQL injection.

Leave a commentMS SQL Server, Programming, SQL Code SnippetsSecurity, SQL Injection

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 of “undoing” what was started if something were to fail […]

MS SQL Server, SQL Code SnippetsError Handling, SQL Development

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, scan them, and then process the device. Here is another […]

Leave a commentBarcode Readers, Datalogic Memor™, MS SQL Server, NetTrax.NET, 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 24 characters).  SQL Server has a REPLICATE function that makes […]

Leave a commentMS SQL Server, 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: The EXECUTE permission was denied on the object ‘aspnet_CheckSchemaVersion’, database […]

Leave a commentDatabase, MS SQL Server, Programming, 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 just the filename as a column. I couldn’t use a […]

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 create a table (tbl_LUState) and will populate the table with […]

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 logical name: Using the following SQL script the logical name […]

Database, MS SQL Server, SQL Code SnippetsMS SQL Server, SQL Development

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 the folder’s tracking id (ParentTracking_ID) assigned to the document. SELECT […]

Database, MS SQL Server, SQL Code SnippetsMS SQL Server, Searching, SQL Development

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)

Welcome to NetTrax.NET

NetTrax.NET is a robust tracking system developed by Bradford Systems. We have been writing records management and digital imaging products for over 20 years!

Our customers span many different industries and markets and therefore have very different needs from their tracking system. We have taken many of the features and functions and included them in our newest line of products.

At Bradford Systems we feel that we provide more than just software and more than just consulting. We help our customers gain insight from information. We do this by consolidating resources and finding multi-purpose solutions to reduce costs and solve problems.

What about the paperless office? According to a study by The Independent more than twelve billion pages will be printed by mobile devices and printable web content will increase three times by 2012. NetTrax.NET can help you start the transition to a semi-paperless office by creating a process for reducing paper and a solution for effectively managing it. Digital imaging is a very mature process/application. However, we find that many companies, even very large companies, are still using a very immature process. Bradford Systems is a very technologically advanced forward thinking company that can help you drive these policies. At Bradford Systems we tell our clients not to wait for a trigger reason to image but rather drive your own ROI. We can help you discover what that ROI is.

What about destruction? The correct classification of records is crucial to liability. Keeping things too long or not long enough can create major litigation risks for companies. Sometimes the risks are so great that they can shutdown a successful company! NetTrax.NET has a full featured retention management system to classify, report against, and destroy records.

Many companies are looking for a magic product. What you really need is a refined process and a partner with years of experience in the industry. You get that from Bradford Systems and NetTrax.NET

Check out the Media section to view screenshots and video demonstrations. Or if you would like additional information feel free to Contact Us to have a representative contact you right away!


Copyright ©2022 Bradford Systems Corporation, All rights reserved.
Magazine Plus by WEN Themes