Oh...

In this case Access is for sure an alternative. I use the SQL Server Reporting Services to create readonly interfaces (grids) from data. When a more elaborated interface is needed,...

Hi,

I've been there. Believe me: SQL. For any size of application. It really pays off in Web environment as well as in local Windows applications. Throw in SQL Express and...

Two things:

1. you CONTACTID column is not an IDENTITY;

2. the best way to go here is not to use @@IDENTITY. If your first INSERT...SELECT returns more than 1 row your...

Carlo,

Are you experiencing problems with your application? If separate processes are affecting different rows, I don't see where locking can be an issue. Unless there is a table lock taking...