This question is like kicking of an open door.

I had a little hesitation about the NULL values, but I gambled it right !

Thanks.

Yeah, special numbers has a special meaning in terms of formatting

Nice, cascading.

It suprished me that in the Message Pane only :

(1 row(s) affected)

is shown.

Nice question.

I knew it, but it's funny to realise.

Great ! That cascading

It returns indeed 220, but that is an errornumber.

So I doubted whether 220 or error.

I have chosen 220.

Yes Sergiy,

If that was the original question, then you are right.

Now I have had also 2 rows inserted.

Looks easy, but I did expected an error on missing the single quotes, not because of the UNION.

But after execution I noticed that 1 row was inserted.

And yes, the int...

Thanks for your reply Hugo.

It is indeed nasty that sometimes semicolons are not allowed and sometimes you have to use them !

In the programming languages Delphi, C, C++ and C#...

I agree with that Hugo.

So I understand that the question script has been changed.

(I missed the question yesterday so I didn't understand all the replies here)

Yeah, you were right about the foreign key and deletion.

I had it wrong :pinch:

I don't get the explanation.

The ; after the END TRY produced the error.

There is no statement between END TRY and BEGIn CATCH !

That should be the only possibility at such a day .