Calendar

December 2009
S M T W T F S
« Nov   Jan »
 12345
6789101112
13141516171819
20212223242526
2728293031  

Windows XP and DOS Unix Style Tail Command

The tail command, on most Unix-style operating systems, lets you display the last 10 or so lines of a text file. Tail also supports a feature allowing you to display new lines as they appear in the file. This feature of tail is most commonly used for displaying the results of log or debug files, [...]

SQL Change column name in table

Using the Query Analyzer may not be the right way always, you can use the SQL syntax as given below, if you are unable to have access to use the query analyzer
For Oracle 9i, the syntax is :
ALTER TABLE table_name
RENAME COLUMN old_name to new_name;
For Microsoft SQL the syntax is :
EXEC sp_rename ‘Table.[OldColumnName]‘, NewColumnName, ‘COLUMN’
*Note here [...]