copy a column from one table to another [modified]
Database
2
Posts
2
Posters
0
Views
1
Watching
-
How can i copy a column from one table to another (data and schema) at runtime in vs 2005? the data and schema are read from xml files -- modified at 8:44 Sunday 14th January, 2007
rzvme
Write an sp, that will do that and call it from your code. The sp (for SQL server) will look something like this:
INSERT INTO [InsertDB].[dbo].[InsertTable] ( [ColumnName1],[ColumnName2] ) SELECT [ColumnName1],[ColumnName2] FROM [SourceDB].[dbo].[SourceTable]Sincerely, Elina Life is great!!! Enjoy every moment of it! :-O