i do
1 TopicWhen i do select into query, insert fails, but the table is created. why!?
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. thanks2KViews0likes0Comments