The Undertaker, whose real name is Mark Calaway, wishes Sting the best of luck and is reportedly looking forward to facing the pro wrestling legend in the ring. Calaway's intention to face Sting in the ring has lead many wrestling fans speculating that the WCW superstar will face The Undertaker first.
To rename a column using Object Explorer. In Object Explorer, connect to an instance of Database Engine. In Object Explorer, right-click the table in which you want to rename columns and choose Rename. Type a new column name.
Splitting Data from One Column into Three Columns. EDITOR'S NOTE: Send your T-SQL questions to SQL Server MVP Itzik Ben-Gan at questions@tsqlsolutions.com. Data in one of my tables is formatted in the ID and Name columns that Figure 1 shows. I need to write T-SQL code that separates the data in the Name column into firstname, surname, and middlenames columns by splitting the names separated by commas.