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

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

Refine your search with one of the following additional tags (with number of items):

T-SQL (2)    
   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,250 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,747 reads
   Items 1 to 2 of 2