取得目前日期與時間

DateFormat有三種取得實體的方法，分別為getDateInstance、getTimeInstance和getDateTimeInstance，輸出結果會因為取得實體方式而不同。


DateFormat dFormat = DateFormat.getDateTimeInstance(DateFormat.SHORT, DateFormat.SHORT);

Calendar cal = Calendar.getInstance();
Date curDate = cal.getTime();
String dateStr = dFormat.format(curDate);


[SQL Server]Rename a Column Name or Table Name

Introduction

Renaming any column
SP_RENAME ‘TableName.[OldColumnName]‘ , ‘[NewColumnName]‘, ‘COLUMN’

Renaming any object (table, sp etc)
SP_RENAME ‘[OldTableName]‘ , ‘[NewTableName]‘

Application
1.Renaming database table column to new name.

   sp_RENAME ‘Table_First.Name’, ‘NameChange’ , ‘COLUMN’

2.Renaming database table to new name.

   SP_RENAME ‘Table_First’, ‘Table_Last’