• DTML (1/25/2015)


    My apologies Hugo - it appears the ANSI_NULL_DEFAULT was not at all the problem - it was the fact that I had a previous MYTABLE in my system which I created as having myid as a PK!!

    Thanks for getting back to this, DTML! I was convinced that there had to be some logical explanation for what you witnessed. I am very glad that you found this explanation, and shared it with us.

    Well done! 😉


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/