SQL Server Central is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Content with tags T-SQL, SQL Server 2005, Advanced Querying, SQL Server 2005 - TSQL Rss

   Items 1 to 2 of 2   
 

Write PIVOT queries in SQL Server 2005

New to SQL Server 2005 is the PIVOT operator, which gives you the ability to rotate row level data into tabular data without the use of the CASE statement, as was necessary in previous versions of SQL Server.  Read more...
By Additional Articles 2007/01/11 | Source: Builder.com | Category: Advanced Querying
Rating:  Rate this |  Briefcase | 4,327 reads

Fast Text Processing in SQL Server

Processing text or long strings usually reduces SQL to a prosaic procedural language. Learn a few techniques for facilitating speedy text processing in SQL.   Read more...
By Additional Articles 2006/05/10 | Source: DevX | Category: Advanced Querying
Rating:  Rate this |  Briefcase | 3,804 reads
   Items 1 to 2 of 2