Integer Types

There are many different ways to store integers in SQL, how do you know which is the best? I have worked in organisations where it was decided that BIGINT should always be used for primary keys, because then we'd never run out of numbers. While the argument was true, they wouldn't run out of numbers, …

Column name or number of supplied values does not match table definition

I came across this familiar error recently when writing some scripts. Normally I see this error when doing an insert, and the number of columns you've specified doesn't match the number of values you've provided. But this time it was in an UPDATE script. Here's the script: When this runs it gives an error Column …

Asking for Help

I always think it's a great idea to ask for help. When I was a kid, my parents taught me that it's always a good idea to ask for help - the worst that will happen is they'll say no. In IT there is too much to learn so I always think it's a great idea …