BIN2 does distinguish between uppercase and lowercase, it just sorts them differently from CS collations.

Just in case someone comes here with a similar problem, the article below has an explanation of a possible scenario and the solution.

TRY_CAST Arithmetic Overflow Error - Purple Frog Systems

The decision on whether or not to pre-approve when I've suggested changes depends on a few things for me.

• How much do I trust that developer?
• How urgent is the...

I like this idea in theory, but it could cause a bit of drag in practice due to people having to re-skill. At my current employer, I started as a...

I tend to update SSMS fairly soon after the new version is announced. Same for the Red Gate add-ins.

For Visual Studio, I tend to wait quite a while because I...

If you drop the brackets around (2002 AS year), it would work. Alternatively, you could SELECT from the Books table first and then the SELECT against New would inherit the...

Removed duplicate post.

• This reply was modified 1 year, 1 month ago by  Chris Wooding.

The syntax I've used in the past for this type of thing is below. Because TRUNCATE needs higher permissions than DELETE, we had to create a special user for procedures...

There's nothing to stop you from having the normalised model and building a dimensional model on top of that. Then you have the best of both worlds when it comes...

I also think "We can't guess" is correct, but for a different reason. Rows could have been inserted by other users in the time between the insert statement and the...

You are declaring @TrackingNO as a variable when there is already a parameter by that name in the procedure declaration.

The only thing the original article tells me is that some PhDs in Computability Theory are worth jack sh1t.

The amount of computation could be reduced by restricting the list of divisors to just the prime numbers already found that are <= SQRT(candidate). The problem is that the IO...

I've recently been using Snowflake and the SQL there is very similar, but not quite the same. The main problem I have is not with the flavour of SQL, but...

You only need to test up to the square root of a number to test for primality, which is quite a saving:

declare @n ...