If you have two data tables with the same data columns, you can merge them quite easily. Merge Data Tables dataTableEuropeanCities and dataTableAsianCities are two datatables with same schema. They can be merged with one line of code. DataTable dataTableEuropeanCities = new DataTable(); DataTable dataTableAsianCities = new DataTable(); dataTableEuropeanCities.Merge(dataTableAsianCities);
You can not use the ALTER TABLE statement in SQL Server to rename a column in a table. You can however, use the sp_rename stored procedure if you do not want to drop and recreate the table again. Listing 1. Here is an example of the sp_rename syntax sp_rename ‘TABLE.OLD_COLUMN_NAME’,
You can not use the ALTER TABLE statement in SQL Server to rename a column in a table. You can however, use the sp_rename stored procedure if you do not want to drop and recreate the table again. Listing 1. Here is an example of the sp_rename syntax sp_rename ‘TABLE.OLD_COLUMN_NAME’,