DateFormat dFormat = DateFormat.getDateTimeInstance(DateFormat.SHORT, DateFormat.SHORT);
Calendar cal = Calendar.getInstance();
Date curDate = cal.getTime();
String dateStr = dFormat.format(curDate);
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’
import java.util.Properties;
import java.util.Enumeration;
public class testSystemProp{
public static void main(String args[]){
Properties props = System.getProperties();
Enumeration enum = props.propertyNames();
for (; enum.hasMoreElements(); ) {
String propName = (String)enum.nextElement();
String propValue = (String)props.get(propName);
System.out.println(propName + ":\t" + propValue);
}
}
}
