Blogs sobre: T Sql

Blog em Destaque

Converting seconds - SQL

For those works with many databases… mssql, oracle, sybase, progress sometimes has troubles with migrations. The Date/Time types sometimes are a big problem. This tip is how to convert seconds. … mais →

sl4v3r

Converting seconds - SQL

sl4v3r wrote 1 month ago: For those works with many databases… mssql, oracle, sybase, progress sometimes has troubles wi … more →

Tags: SQL, ASE, Convert, Date, DATEPART, example, hh:mm:ss, hour, Microsoft

Encrypting a view - SQL

sl4v3r wrote 1 month ago: Sometimes we need to hide some information of a database. Here is a tip to encrypt a description of … more →

Tags: SQL, encrypt, encryption, example, Microsoft, MSSQL, server, View, with

Errors in SQL Server

sl4v3r wrote 1 month ago: If you had worked with Sql certainly you saw the error message below. Msg 2627, Level 14, State 1, L … more →

Tags: SQL, Error, example, Levél, line, MSG, MSSQL, server, state

Use JOIN or WHERE to join tables?

sl4v3r wrote 1 month ago: There are two methods… WHERE SELECT MYTABLE.Name, MYTABLE2.Age FROM MYTABLE, MYTABLE2 WHERE MY … more →

Tags: SQL, ASE, best, example, Join, MSSQL, ON, Performance, server

Using TOP with SELECT Statements

sl4v3r wrote 1 month ago: Hi All, I’m back… Long time anh???… lol The TOP option is used for limiting the ou … more →

Tags: SQL, ASE, MSSQL, option, percent, sample, server, sybase, TOP

Compute clause in SQL

sl4v3r wrote 1 month ago: Hi, One of my favorites languages is SQL. Almost six years working with it… MSSQL, Oracle, Mys … more →

Tags: SQL, agregate, ASE, Clause, Code, compute, sample, server, sum

Call a DTS package from T-SQL

sl4v3r wrote 2 months ago: People wich work with many technologies has many troubles to convert and migrate the data. Fortunate … more →

Tags: SQL, procedure, server, stored, Code, example, MSSQL, Microsoft, xp_cmdshell

Novidades SQL Server 2008 - Instrução MERGE

marceloneias wrote 3 months ago: Como certeza uma das maiores novidades do SQL Server 2008 é a instrução MERGE. Merge significa … more →

Tags: SQL Server, SQL Server 2008, insert, merge, Update, delete

Novidades SQL Server 2008 - Insert com múltiplos valores

marceloneias wrote 3 months ago:   Uma grande novidade incorporada na versão do SQL Server 2008 é a possibilidade de realizar um inse … more →

Tags: SQL Server, insert, múltiplos valores, select, SQL Server 2005, SQL Server 2008, union all

Fugindo do table scan

sl4v3r wrote 3 months ago: Jah fiz alguns posts sobre performance, talvez seja a hora de criar mais uma categoria… rsrsrs … more →

Tags: SQL, Performance, Where?, EXEMPLO, Table, Registro, Banco, dados, Scan

Fugindo do table scan

sl4v3r wrote 3 months ago: Jah fiz alguns posts sobre performance, talvez seja a hora de criar mais uma categoria… rsrsrs … more →

Tags: SQL, Performance, Where?, EXEMPLO, Table, Registro, Banco, dados, Scan

Novidades SQL Server 2008 - Inicialização de variáveis locais

marceloneias wrote 3 months ago:   Uma das novidades no SQL Server 2008 é a declaração e inicialização de variáveis locais. Até a ver … more →

Tags: SQL Server, Declare, Inicialização, Novidade, SQL 2005, SQL 2008, variável

NOT ou OR

sl4v3r wrote 3 months ago: Existe uma regra basica para banco de dados… Tudo que eh NOT ou OR prejudica a performance do … more →

Tags: SQL, Performance, exists, EXEMPLO, Not, Or, SGBD, Banco, dados

NOT ou OR

sl4v3r wrote 3 months ago: Existe uma regra basica para banco de dados… Tudo que eh NOT ou OR prejudica a performance do … more →

Tags: SQL, Performance, exists, EXEMPLO, Not, Or, SGBD, Banco, dados

Case in Sql

sl4v3r wrote 4 months ago: This example shows the use of CASE in SQL. select case gender when ‘M’ then ‘Male … more →

Tags: SQL, sybase, select, case, server, Then, Else, sample, example

Case in Sql

sl4v3r wrote 4 months ago: This example shows the use of CASE in SQL. select case gender when ‘M’ then ‘Male … more →

Tags: SQL, sybase, select, case, server, Then, Else, sample, example

Using the xp_cmdshell

sl4v3r wrote 5 months ago: Using the xp_cmdshell in sql… Syntax xp_cmdshell ‘my_command’ [, no_output] Sampl … more →

Tags: SQL, sybase, server, shell, CMD, MSSQL, ASE, TSql, xp_cmdshell

Using the xp_cmdshell

sl4v3r wrote 5 months ago: Using the xp_cmdshell in sql… Syntax xp_cmdshell ‘my_command’ [, no_output] Sampl … more →

Tags: SQL, sybase, server, shell, CMD, MSSQL, ASE, TSql, xp_cmdshell

sp_depends

sl4v3r wrote 5 months ago: The sp_depends shows objects related to the specified object. Syntax sp_depends object_name Sample s … more →

Tags: SQL, sybase, server, sample, Syntax, MSSQL, ASE, sp_depends


Have your say. Start a blog.

See our free features →

Etiquetas Relacionadas
Tudo →

Acompanhe essa tag via RSS

Encontrar outros itens com a tag “t-sql”:
Technorati Del.icio.us IceRocket