It is a much better practice to use FORMAT rather than CONVERT as you can specify the required format, i.e. 'dd.mm.yyyy' rather than some magic number that no one can...

date format 101 is mm/dd/yyy and therefore the answer is 4

I picked the right answer of 2 rows, but it was not because of the Autocommit feature but there is no error checking done - either checking for @@ERROR or...

I'm not American so I thought the answer would be more related to SQL Server!!!!!

:crazy:

Since the question is wrong then everyone who selected "-1,0,1" should get a point!

:-):-D