You're missing a comma after Compulsory DECIMAL (5,3). Then, for your computed columns, the correct syntax is [Compul and Optionals] AS Compulsory + Optionals, ({Column...

I think the OP is saying that both tables already exist. If that is the case, you can't use the INTO clause, you need to use an INSERT statement. If...

@@language should be British if you're on a login with the language set to British (@@LANGUAGE returns the language of the currentc session). The fact that it's not proves my...

Well, those are more like the values I expected. This is a little messy, but with the values you have supplied get's you the the correct results. Note that the...

Are you sure the languages are configured correctly? I'm on a Server right now with the language set to "English" (American), but my login's language is set to British and...

You know there no need to alias an object as itself right? For example: ConnectoryStore AS ConnectoryStore. Normally Aliases are to make your code, and object's name, more...

Could we have some more examples? Perhaps we can spot a pattern then. What is the size of your varchar column as well, perhaps it's suffering some truncation?

But...

This conversation puts me very much in mind of a new piece of software we're using at the office, which is setup with an email address being the primary key....

I don't understand you question. How are you determining that value of the variable @Count? Based on the vague information we have though, I doubt this needs either...

Got caught out on this one. Initially DBMail wasn't supported on Linux, and completely forgot it was added later. 🙂

Are you using the same credentials in SSMS as you are using in the application? I suspect the answer is "No".