Category: Banco de Dados

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

Consulta para ver o conteúdo de procedures

Olá pessoal… Hoje vou mostrar um script SQL que traz o conteúdo de todas as procedures do banco.

16 de agosto de 2017

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

Script para manutenção do SQL Server

Olá pessoal… Trago hoje um script de manutenção para o SQL Server, com intuito de otimizar o Banco de Dados.

2 de agosto de 2017

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

Visualizar todos os gatilhos de uma base no SQL Server

Olá pessoal… Hoje vou mostrar como visualizar todos os gatilhos (triggers) de uma base SQL Server.

26 de julho de 2017

Execução da Procedure

Procedure que retorna o intervalo entre duas datas

Olá pessoal… Hoje vou mostrar uma procedure que desenvolvi para SQL Server que retorna o intervalo entre duas datas.

21 de junho de 2017

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

Script para gerar um “Create Table” de uma tabela existente no SQL Server

Olá pessoal… Hoje vou mostrar como gerar um Create Table completo de uma tabela no SQL Server utilizando uma procedure.

10 de maio de 2017

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

Criando arquivo txt via SQL Server

Olá pessoal… Hoje vou mostrar uma procedure criada no SQL Server para criar arquivos txt via SQL Server, a procedure é a spWriteStringToFile.

5 de abril de 2017