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

Content with tags T-SQL, Advanced Querying, SQL Server 2005 - TSQL, SQL Server 2005 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,305 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,777 reads
   Items 1 to 2 of 2