Tagged: SQL Server

SQL Server

Como ativar o tema escuro no SQL Server

Olá pessoal… Hoje vou mostrar como ativar o tema dark no SQL Server Management Studio.

13 de fevereiro de 2019

While True - Enquanto for verdadeiro

Atualização Base de Conhecimento – Janeiro de 2019

Foram adicionados 15 artigos na base de conhecimento (FWMSPrinter, ElapTime, Métodos MVC, SELECT com WHERE, etc).

31 de janeiro de 2019

AdvPL

Como ver o conteúdo de um campo MEMO via SQL Server

Olá pessoal… Hoje vou mostrar um exemplo simples de como pegar o conteúdo de um campo MEMO do SQL Server via AdvPL (tanto o...

21 de novembro de 2018

SQL Server

<img width="256" height="144" data-src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=256%2C144&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image lazyload" alt="SQL Server" decoding="async" loading="lazy" data-attachment-id="6680" data-permalink="https://terminaldeinformacao.com/2016/12/21/verificando-tamanho-das-tabelas-sql-server/sql-2/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=1920%2C1200&ssl=1" data-orig-size="1920,1200" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="sql" data-image-description="<p>SQL Server</p> " data-image-caption="<p>SQL Server</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=300%2C188&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=720%2C450&ssl=1" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" style="--smush-placeholder-width: 256px; --smush-placeholder-aspect-ratio: 256/144;" /><noscript><img width="256" height="144" src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=256%2C144&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image" alt="SQL Server" decoding="async" loading="lazy" data-attachment-id="6680" data-permalink="https://terminaldeinformacao.com/2016/12/21/verificando-tamanho-das-tabelas-sql-server/sql-2/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=1920%2C1200&ssl=1" data-orig-size="1920,1200" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="sql" data-image-description="<p>SQL Server</p> " data-image-caption="<p>SQL Server</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=300%2C188&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=720%2C450&ssl=1" />

Função que retorna a diferença entre 2 dias e horas no SQL Server

Olá pessoal… Hoje vou mostrar uma função desenvolvida em SQL Server, que retorna a diferença entre duas datas em Dias, Horas, Minutos e Segundos.

31 de outubro de 2018

SQL Server

<img width="256" height="144" data-src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=256%2C144&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image lazyload" alt="SQL Server" decoding="async" loading="lazy" data-attachment-id="6680" data-permalink="https://terminaldeinformacao.com/2016/12/21/verificando-tamanho-das-tabelas-sql-server/sql-2/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=1920%2C1200&ssl=1" data-orig-size="1920,1200" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="sql" data-image-description="<p>SQL Server</p> " data-image-caption="<p>SQL Server</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=300%2C188&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=720%2C450&ssl=1" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" style="--smush-placeholder-width: 256px; --smush-placeholder-aspect-ratio: 256/144;" /><noscript><img width="256" height="144" src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=256%2C144&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image" alt="SQL Server" decoding="async" loading="lazy" data-attachment-id="6680" data-permalink="https://terminaldeinformacao.com/2016/12/21/verificando-tamanho-das-tabelas-sql-server/sql-2/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=1920%2C1200&ssl=1" data-orig-size="1920,1200" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="sql" data-image-description="<p>SQL Server</p> " data-image-caption="<p>SQL Server</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=300%2C188&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=720%2C450&ssl=1" />

Como alterar a Collation do SQL Server através de uma procedure

Olá pessoal… Hoje vou mostrar como alterar a Collation do SQL Server para todas as tabelas via script.

22 de agosto de 2018

SQL Server

<img width="256" height="144" data-src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=256%2C144&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image lazyload" alt="SQL Server" decoding="async" loading="lazy" data-attachment-id="6680" data-permalink="https://terminaldeinformacao.com/2016/12/21/verificando-tamanho-das-tabelas-sql-server/sql-2/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=1920%2C1200&ssl=1" data-orig-size="1920,1200" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="sql" data-image-description="<p>SQL Server</p> " data-image-caption="<p>SQL Server</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=300%2C188&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=720%2C450&ssl=1" src="data:image/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==" style="--smush-placeholder-width: 256px; --smush-placeholder-aspect-ratio: 256/144;" /><noscript><img width="256" height="144" src="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?resize=256%2C144&ssl=1" class="attachment-blogrow-small size-blogrow-small wp-post-image" alt="SQL Server" decoding="async" loading="lazy" data-attachment-id="6680" data-permalink="https://terminaldeinformacao.com/2016/12/21/verificando-tamanho-das-tabelas-sql-server/sql-2/" data-orig-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=1920%2C1200&ssl=1" data-orig-size="1920,1200" data-comments-opened="1" data-image-meta="{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0"}" data-image-title="sql" data-image-description="<p>SQL Server</p> " data-image-caption="<p>SQL Server</p> " data-medium-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=300%2C188&ssl=1" data-large-file="https://i0.wp.com/terminaldeinformacao.com/wp-content/uploads/2016/07/sql.jpg?fit=720%2C450&ssl=1" />

Função para tirar acento no SQL Server

Olá pessoal… Recentemente precisei criar uma função que retirasse acentos via SQL Server.

16 de maio de 2018