Create report in Alpha Five - One Report Does It All With Alpha Anywhere

This is a technique that can save you a lot of time and effort when creating Alpha Anywhere reports. No longer is there a need to create a report for every single type of scenario. We are going to show you how to create versatile reports capable of being used in many different scenarios.

Why Convert Access To SQL

The Advantages of Converting from MS Access to SQL Server is that the performance, and processing time are all significantly improved.

Create Unique Invoice Number in SQL

A better solution will have a separate table so you can generate Invoice numbers. This way you let IDENTITY field work for you with any Insert as shown in the below Stored Procedure.

How to solve identity problem in SQL 2012

Microsoft changed the Identity behavior to jump in increment of 1000 or 10000 whenever the SQL Server 2012 restart. For example: we have a Primary Key that was 10012, if you re-start the SQL server instant, then in the next Insert record you will get the Primary Key as 11012.