Posts by Thaisjt Jt • 23 points
3 posts
-
0
votes1
answer566
viewsA: How to add equal amount SQL?
Hello, you will need to leave these two with the same name, after that you just need to do a group by. select prod_nome, sum(qtde) from teste group by prod_nome In doing so, in addition to adding…
-
2
votes1
answer627
viewsQ: OPENROWSET - How to assign a variable instead of the file name to open?
I do this command and I do it right: SELECT * FROM OPENROWSET( 'Microsoft.ACE.OLEDB.12.0', 'Excel 12.0 Xml;Database=\\00.000.00.0000\Arquivos\TI\Arquivos\252203408.xlsx;HDR=YES', 'SELECT * FROM…
-
0
votes1
answer129
viewsQ: xp_cmdshell how to place folders that have space?
I put a folder in the terminal exec xp_cmdshell 'dir b:\teste\*xlsx*' exec xp_cmdshell 'dir b:\teste teste\*xlsx*' When I add the space it does not find. It is impossible to change the name of all…