SQL 判断表是否存在
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'Users_TEMP') AND type in (N'U')) BEGIN DROP TABLE Users_TEMP; SELECT * INTO Users_TEMP FROM Users WHERE 1=2; END ELSE BEGIN SELECT * INTO Users_TEMP FROM Users WHERE 1=2; END;
 
                    
                
 
                
            
         浙公网安备 33010602011771号
浙公网安备 33010602011771号