Blogs sobre: Mssql
Blog em Destaque
T-SQL - Finding strings in procs and triggers
Hi all, This post is about how to find a STRING in stored procedures and triggers. This tip is VERY useful for those who works with T-SQL. code select distinct(object_name(id)) from syscomments where … mais →
sl4v3r
T-SQL - Finding strings in procs and triggers
sl4v3r wrote 1 month ago: Hi all, This post is about how to find a STRING in stored procedures and triggers. This tip is VERY … more →
Alternative to select count(*)
sl4v3r wrote 3 months ago: Hi all, Long time annnh?? lol This post is about an alternative to select count(*) in Sql Server. Us … more →
Working with XML in SQL Server 2000
sl4v3r wrote 4 months ago: Working with XML in SQL Server 2000 Unfortunetly sometimes we have to work with old technologies (li … more →
Converting seconds - SQL
sl4v3r wrote 5 months ago: For those works with many databases… mssql, oracle, sybase, progress sometimes has troubles wi … more →
Encrypting a view - SQL
sl4v3r wrote 5 months ago: Sometimes we need to hide some information of a database. Here is a tip to encrypt a description of … more →
Errors in SQL Server
sl4v3r wrote 6 months ago: If you had worked with Sql certainly you saw the error message below. Msg 2627, Level 14, State 1, L … more →
Use JOIN or WHERE to join tables?
sl4v3r wrote 6 months ago: There are two methods… WHERE SELECT MYTABLE.Name, MYTABLE2.Age FROM MYTABLE, MYTABLE2 WHERE MY … more →
Using TOP with SELECT Statements
sl4v3r wrote 6 months ago: Hi All, I’m back… Long time anh???… lol The TOP option is used for limiting the ou … more →
Call a DTS package from T-SQL
sl4v3r wrote 7 months ago: People wich work with many technologies has many troubles to convert and migrate the data. Fortunate … more →
Como configurar Conexão Remota no SQL Server 2005
littleoak wrote 9 months ago: Fonte: http://www.linhadecodigo.com.br/Artigo.aspx?id=1260 Dono: http://www.linhadecodigo.com.br/Col … more →
Boot in Sybase
sl4v3r wrote 9 months ago: Global variables in Sybase about boot… very useful. Bad news… doesn’t work in MSSQ … more →
Boot in Sybase
sl4v3r wrote 9 months ago: Global variables in Sybase about boot… very useful. Bad news… doesn’t work in MSSQ … more →
Case in Sql
sl4v3r wrote 9 months ago: This example shows the use of CASE in SQL. select case gender when ‘M’ then ‘Male … more →
Case in Sql
sl4v3r wrote 9 months ago: This example shows the use of CASE in SQL. select case gender when ‘M’ then ‘Male … more →
Using the xp_cmdshell
sl4v3r wrote 10 months ago: Using the xp_cmdshell in sql… Syntax xp_cmdshell ‘my_command’ [, no_output] Sample … more →
Using the xp_cmdshell
sl4v3r wrote 10 months ago: Using the xp_cmdshell in sql… Syntax xp_cmdshell ‘my_command’ [, no_output] Sample … more →
sp_depends
sl4v3r wrote 10 months ago: The sp_depends shows objects related to the specified object. Syntax sp_depends object_name Sample s … more →
sp_depends
sl4v3r wrote 10 months ago: The sp_depends shows objects related to the specified object. Syntax sp_depends object_name Sample s … more →
Trigger no Sql Server
sl4v3r wrote 11 months ago: Para criar uma trigger no Sql Server eh bem simples, segue um exemplo de trigger de insert. CREATE T … more →
