Soap_Leutenant的博客

select * from ( select CASE WHEN name1 is null then name2 ELSE name1 end as name, COALESCE(REGCOUNT,0) as reg_count, COALESCE(DETAINED_FIRST,0) as DETAINED_FIRST, COALESCE(DETAINED_SEC,0...

sql server 修改表中列名： rename不能用，我的2012反正不能用。 APP_WW_WEEK_CHECK表中SAMPLINGPIPLELINE列名改为semaphore： EXEC sp_rename 'APP_WW_WEEK_CHECK.SAMPLINGPIPLELINE' , 'semaphore' ...