Posts by Vladimir • 111 points
3 posts
-
0
votes2
answers1830
viewsQ: Excel - How to concatenate cell range?
How do I concatenate a range of cells in Excel? For example: I have a column with many cells containing text information and I would like to concatenate them, but when using the concatenate function…
-
5
votes4
answers33983
viewsA: How to copy column data from one table to another table
The script to update the email from the backup table can be done as follows: /* AMBIENTE DE TESTE: Tabelas temporárias para testar o script */ create global temporary table tmp_uc ( idconsumidor…
-
6
votes4
answers40379
viewsA: How to replace column text in SQL Server (tsql)?
I find it interesting to carry out updates, however simple they may be, as follows: update t set nomeColuna = replace(nomeColuna, 'xx', 'yy') --select * --select pode ser executado e trará os mesmos…