Note: If desired, you can use a column-list that follows the table alias, such as as t1 (invnum,billedon,amtinus,name) to rename the columns; however, this is not necessary. If you choose to rename ...

Have a live SQL Server 2000 db with approx. 100000 records in it, lots of users etc.I just want to rename a field so I'm assuming that since this is purely ...