Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on May 2nd, 2012  |  syntax: None  |  size: 1.05 KB  |  hits: 13  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. SQL Query to fill column with combination of other columns
  2. ID | Parameter1 | Parameter 2  | Multiplication
  3. 1  |     1024   |     100      |
  4. 2  |     1200   |     200      |
  5. 3  |     1600   |     300      |
  6. 4  |     1900   |     400      |
  7.        
  8. ID | Parameter1 | Parameter 2  | Multiplication
  9. 1  |     1024   |     100      |   1024_100
  10. 2  |     1200   |     200      |   1200_200
  11. 3  |     1600   |     300      |   1600_300
  12. 4  |     1900   |     400      |   1900_400
  13.        
  14. UPDATE Table1 SET Multiplication = CAST(Parameter1 AS VARCHAR(10)) + '_' + CAST(Parameter2 AS VARCHAR(10))
  15.        
  16. UPDATE Table1 SET Multiplication = Parameter1 + '_' + Parameter2
  17.        
  18. update Table1 set
  19.     Multiplication = concat(cast(Parameter1 as char), '_', cast(Parameter2 as char))
  20.        
  21. update tablename
  22. set Multiplication = convert(varchar, Parameter1) + '_' + convert(varchar, Parameter2)
  23.        
  24. ALTER TABLE myTable
  25.     ADD myJoinedColumn AS CAST(Parameter1 AS VARCHAR(10)) + '_' + CAST(Parameter2 AS VARCHAR(10))
  26.        
  27. ALTER TABLE myTable
  28.     ADD myJoinedColumn AS (Parameter1 + '_' + Parameter2)
create a new version of this paste RAW Paste Data