Tags » Database Tuning

SQL Server Conversion failed when converting the varchar value 'xxxx' to data type int - A Root Cause Analysis

There are many reasons but this is what I ran into:

The query was simple as follows:

select top 1 stopid from busstops where code = cast('836' as int)
… 472 more words
SQL Server

Access: Tuning Your Client Settings

Microsoft Access is a great application for creating databases. It is also used as a tool for just storing data. Where Excel will limit you to just over a million rows this application has no issues whatsoever to store a couple of million rows. 928 more words

Office Tips And Tricks