tag:blogger.com,1999:blog-6100419445090790199.comments2023-09-24T08:17:47.043-03:00SQL BrasilCesar Blummhttp://www.blogger.com/profile/17590220931166448799noreply@blogger.comBlogger119125tag:blogger.com,1999:blog-6100419445090790199.post-54182864361315726742023-07-05T19:43:47.623-03:002023-07-05T19:43:47.623-03:00Você me salvou não conhecia esta forma, muito mais...Você me salvou não conhecia esta forma, muito mais rápido.Masterhttps://www.blogger.com/profile/15727172458382490969noreply@blogger.comtag:blogger.com,1999:blog-6100419445090790199.post-50542670326213604172021-10-27T16:49:15.719-03:002021-10-27T16:49:15.719-03:00Muito bom. Parabéns!Muito bom. Parabéns!Fabrício Silvahttps://www.blogger.com/profile/00896343383015859111noreply@blogger.comtag:blogger.com,1999:blog-6100419445090790199.post-89755035413080937462021-07-13T23:54:45.782-03:002021-07-13T23:54:45.782-03:00Boaa deu certo obgdoBoaa deu certo obgdoFR Solutionshttps://www.blogger.com/profile/02306876530475868830noreply@blogger.comtag:blogger.com,1999:blog-6100419445090790199.post-5795257935668640992021-04-18T12:07:45.536-03:002021-04-18T12:07:45.536-03:00Excelente dica. Era isso mesmo q estava procurando...Excelente dica. Era isso mesmo q estava procurando ha uma semana. Muito ObrigadoMuriloCunhahttps://www.blogger.com/profile/16254226847964566138noreply@blogger.comtag:blogger.com,1999:blog-6100419445090790199.post-42666405407751272962021-03-26T11:48:19.078-03:002021-03-26T11:48:19.078-03:00DEUSSSSSDEUSSSSSAnonymoushttps://www.blogger.com/profile/17662673298164579508noreply@blogger.comtag:blogger.com,1999:blog-6100419445090790199.post-28793177367166428612020-09-25T10:04:17.277-03:002020-09-25T10:04:17.277-03:00No meu caso não deu certo, mesmo reiniciando o ser...No meu caso não deu certo, mesmo reiniciando o serviço do SQLAnonymoushttps://www.blogger.com/profile/18021915461362808816noreply@blogger.comtag:blogger.com,1999:blog-6100419445090790199.post-37411800898960793622020-09-08T23:24:26.000-03:002020-09-08T23:24:26.000-03:00Após executar o comando de recovery, basta dar ref...Após executar o comando de recovery, basta dar refresh nos databases que o banco aparece normalmente em seguidaAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6100419445090790199.post-45422653710723128462020-09-08T21:58:55.330-03:002020-09-08T21:58:55.330-03:00Comigo tbm foi a mesma coisa. Mas deu certo o reco...Comigo tbm foi a mesma coisa. Mas deu certo o recovery seguindo a dica do amigoAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6100419445090790199.post-22875607953298673062020-09-08T21:50:56.541-03:002020-09-08T21:50:56.541-03:00Valeu. Salvou meu dia, com certeza!!Valeu. Salvou meu dia, com certeza!!Wilsonhttps://www.blogger.com/profile/02255430628624937360noreply@blogger.comtag:blogger.com,1999:blog-6100419445090790199.post-73361783378175730382020-08-30T13:37:26.677-03:002020-08-30T13:37:26.677-03:00Muito obrigado! Muito obrigado! Andrehttps://www.blogger.com/profile/12832356969844177311noreply@blogger.comtag:blogger.com,1999:blog-6100419445090790199.post-40149345576395504332020-06-20T00:19:21.400-03:002020-06-20T00:19:21.400-03:00Obrigado!!! ja estamos em 2020 e a informação cont...Obrigado!!! ja estamos em 2020 e a informação continua sendo muito util!!!Adaildo Andradehttps://www.blogger.com/profile/10819894723786608905noreply@blogger.comtag:blogger.com,1999:blog-6100419445090790199.post-50738533146919835412020-05-18T14:15:19.652-03:002020-05-18T14:15:19.652-03:00em 2020 ainda salvando vidas vlw!!em 2020 ainda salvando vidas vlw!!jcamparotohttps://www.blogger.com/profile/08916921662362825265noreply@blogger.comtag:blogger.com,1999:blog-6100419445090790199.post-40794416663751840002020-05-08T01:24:46.587-03:002020-05-08T01:24:46.587-03:00Boa dica, quem sabe eu não uso lá no meu site de e...Boa dica, quem sabe eu não uso lá no meu site de <a href="https://exerciciosresolvidos.com.br/exercicios-de-sql-resolvidos-basicos-e-avancados/" rel="nofollow">exercícios</a>João Ricardohttps://www.blogger.com/profile/15561396336495087726noreply@blogger.comtag:blogger.com,1999:blog-6100419445090790199.post-899609233433865082020-05-04T10:10:50.473-03:002020-05-04T10:10:50.473-03:00Obrigado! Deu certo aqui.Obrigado! Deu certo aqui.Diego Macedohttps://www.blogger.com/profile/13763986213948140951noreply@blogger.comtag:blogger.com,1999:blog-6100419445090790199.post-10781054896611173622020-04-17T16:25:59.821-03:002020-04-17T16:25:59.821-03:00Desta forma é impresso com os decimais corretament...Desta forma é impresso com os decimais corretamente mais não preenche com zeros a esquerda.<br /><br />to_char (F.vltitulo, '9G999G990D9999') as vltitulo,<br />O resultado fica assim : 99,0000<br /><br />desta forma abaixo o resultado fica:<br />lpad (F.vltitulo,14,'0' as vltitulo,<br /><br />000000000099,00 quando eu preciso que fique 0000000099,0000Edinaldo Santanahttps://www.blogger.com/profile/12100307137617432799noreply@blogger.comtag:blogger.com,1999:blog-6100419445090790199.post-80487601330888741172020-04-17T16:23:02.057-03:002020-04-17T16:23:02.057-03:00Boa tarde. alguém poderia me ajudar e converter um...Boa tarde. alguém poderia me ajudar e converter um campo valor para que seja apresentado na consulta com zeros a esquerda e com 4 decimais?Edinaldo Santanahttps://www.blogger.com/profile/12100307137617432799noreply@blogger.comtag:blogger.com,1999:blog-6100419445090790199.post-36852811012670332412020-03-20T18:48:38.142-03:002020-03-20T18:48:38.142-03:00No meu caso executei o comando e continuou, depois...No meu caso executei o comando e continuou, depois que eu sai do SQL, parei os serviços dele, depois subi e entrei, funcionou.celiohttps://www.blogger.com/profile/00843381547825208782noreply@blogger.comtag:blogger.com,1999:blog-6100419445090790199.post-87610729019866972892020-03-20T18:46:57.973-03:002020-03-20T18:46:57.973-03:00Deu certo aqui. ObrigadoDeu certo aqui. Obrigadoceliohttps://www.blogger.com/profile/00843381547825208782noreply@blogger.comtag:blogger.com,1999:blog-6100419445090790199.post-61371868494786242182020-01-29T14:10:48.889-03:002020-01-29T14:10:48.889-03:00Show de bola, eu precisava fazer uma consulta remo...Show de bola, eu precisava fazer uma consulta removendo mascara de telefones e me atendeu muito bem ;) Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6100419445090790199.post-13068038263602361712020-01-21T08:20:04.363-03:002020-01-21T08:20:04.363-03:00Muito bom.Muito bom.Marcoshttps://www.blogger.com/profile/17108726061808750931noreply@blogger.comtag:blogger.com,1999:blog-6100419445090790199.post-82500280611764803192020-01-08T16:21:05.287-03:002020-01-08T16:21:05.287-03:00aqui nao da certo
aqui nao da certo<br />Anonymoushttps://www.blogger.com/profile/04371426538767778184noreply@blogger.comtag:blogger.com,1999:blog-6100419445090790199.post-13893328998730421322019-12-11T15:10:51.111-03:002019-12-11T15:10:51.111-03:00desnecessário...desnecessário...Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6100419445090790199.post-96647458768747252019-10-07T13:55:34.688-03:002019-10-07T13:55:34.688-03:00Top, deu certo.Top, deu certo.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6100419445090790199.post-13048471857604213932019-09-20T11:40:11.987-03:002019-09-20T11:40:11.987-03:00Entre bancos diferentes:
SELECT * INTO [1137].[dbo...Entre bancos diferentes:<br />SELECT * INTO [1137].[dbo].[tbChamadosTemp] FROM [0000].[dbo].[tbChamadosTemp]Nivaldohttps://www.blogger.com/profile/08375662298888271123noreply@blogger.comtag:blogger.com,1999:blog-6100419445090790199.post-84347826800999992542019-09-12T09:56:20.522-03:002019-09-12T09:56:20.522-03:00Seria o inversoSeria o inversoMário Augusto Dinizhttps://www.blogger.com/profile/01355895570527829324noreply@blogger.com