Mar 17 2020 12:53 AM - edited Mar 17 2020 07:30 PM
hi, I'm parksuseong. I am using sql server 2016
I tried to the following query.
SELECT CONVERT(BIGINT, 'A') col1 INTO #tmp
This query is obviously in error. Because it does not convert.
However, the temporary table(#tmp) is created even if the query fails.
why!? I think this is a issue designed, but I want to know for obvious reasons.
thanks