When i do select into query, insert fails, but the table is created. why!?

Copper Contributor

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

 

 

0 Replies