T-SQL判斷Table Column存不存在

IF (SELECT count(*)  FROM INFORMATION_SCHEMA.COLUMNS  WHERE TABLE_NAME = 'TableName' AND COLUMN_NAME='columnName')>0
  BEGIN
    alter table Event ADD StoreAmount [int] NOT NULL DEFAULT 0
  END

Java移除集合內所有的null element

只需一行
resultList.removeAll(java.util.Collections.singleton(null));