Browse by Tags

All Tags » SQL Server » T-SQL (RSS)
Enabling xp_cmdshell in SQL Server 2005
xp_cmdshell is used to spawn a Windows command shell and executes a command line process by the operating system. In order to minimize the security risk of executing malicious code outside SQL Server 2005, xp_cmdshell is disabled by default, and the following...
Posted Tue, Oct 3 2006 by Martin Poon | 2 comment(s)
Filed under: , ,
Bob Beauchemin @ TechEd Hong Kong 2006 - ADO.NET vNext
Bob Beauchemin has just spent a few days in TechEd Hong Kong, giving a few talks on various aspects of SQL Server 2005 and some topics related to .NET development. He has also offered a full-day pre-conference seminar on SQL Server 2005 features like...
Posted Tue, Sep 26 2006 by Martin Poon | with no comments
Filed under: , , , , , ,
SQL Server 2005 ranking functions - RANK(), DENSE_RANK(), NTILE()
RANK() , DENSE_RANK() and NTILE() are newly added functions in SQL Server 2005 T-SQL syntax. Another ranking function is ROW_NUMBER() that I have blogged earlier. RANK() returns the rank of each row within the partition of a result set. When there is...
Posted Fri, Sep 22 2006 by Martin Poon | 4 comment(s)
Filed under: ,
SQL Server 2005 ranking functions - ROW_NUMBER()
ROW_NUMBER() is a new function that is added to the SQL Server 2005 T-SQL syntax. ROW_NUMBER() is used to assign ranks to the result of a query. The basic syntax is ROW_NUMBER() OVER ([<partition_by_clause>]<order_by_clause>) Here comes the...
Posted Thu, Sep 21 2006 by Martin Poon | 2 comment(s)
Filed under: ,