|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
March 24th, 2004, 01:00 PM
|
|||
|
|||
|
Insert column in SQL Server 2000
I have a table with all the fields already filled in(by importing from a table) and have made some manipulations on the data and have created two more columns based on the data available in the table.
My problem is that I need to import a new column (with values) into this table, either by DTS or SQL Query analyzer.
|
|
#4
March 24th, 2004, 07:10 PM
|
|||
|
|||
|
yes... get inner join or outer join with the other table
like this: update T1 set col2:= t2.col2 from table1 t1 inner join table2 t2 on t1.col1=t2.col2
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Insert column in SQL Server 2000 |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
