Tagged: SQL Server

While True - Enquanto for verdadeiro

Atualização Base de Conhecimento – Setembro de 2019

Foram adicionados 21 artigos na base de conhecimento (FWTemporaryTable, AddLegend, SetColumns, MSCBPrinter, etc).

27 de setembro de 2019

SQL Server

<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" 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 ver o conteúdo dos campos LGI e LGA no SQL Server

Basta usar Substring e Convert que você consegue ver o resultado dos campos.

12 de setembro de 2019

SQL Server

<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" 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 descobrir os usuários conectados no SQL Server

Você já precisou saber quem está conectado atualmente nas bases do SQL Server?

3 de julho de 2019

While True - Enquanto for verdadeiro

Atualização Base de Conhecimento – Maio de 2019

Foram adicionados 47 artigos na base de conhecimento (VarInfo, ExecAuto FINA040, TOP, echo, etc).

30 de maio de 2019

SQL Server

<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" />

Convertendo Valor Decimal para Hora em SQL Server

Hoje vou mostrar como converter um valor decimal (numérico) para hora em SQL Server.

15 de maio de 2019

SQL Server

<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 resolver a mensagem de uso exclusivo numa database ao restaurar um backup no SQL Server

Você por acaso, ao restaurar uma database se encontrou com uma mensagem que impedia como prosseguir? Saiba como resolver.

11 de maio de 2019