Archive for April, 2010
PIVOT & UNPIVOT Operators in SQL Server 2008
PIVOT is a new T-SQL operator introduced in SQL Server 2008 which can be used to rotate rows into columns and can create a crosstab query. You can specify the PIVOT operator in FROM clause of your query.
Using PIVOT
Specify the desired values that you want to see in SELECT statement and FROM clause contains the PIVOT statement. Let us take an example
Related Posts:
1 commentDate & Time Data Types in SQL Server 2008
The four new data types for storing dates and times in SQL Server 2008 are
- Date
- Time
- DateTime2
- DateTimeoffset
This post discuss about new date time data types and new date time related functions introduced in SQL Server 2008.
Related Posts:
4 commentsT-SQL TIP in SQL Server 2008
You love this if you write a lot of T-SQL code. This tip I can say as T-SQL language syntax enhancement. The following are the enhancements in T-SQL
- Now We can declare and initialize the variables with single statement.
Related Posts:
No commentsIntroducing DotnetSizzler.com
Dear Readers,
I have come up with a new BLOG DotnetSizzler that serves as a center that offers my services and is a platform for discussion and sharing of Tips & Tricks, Design Principles, Best practices, updates and techniques pertaining to Microsoft Technologies.
Major Stress will be on code snippets on .NET Technologies. I am to share the projects that I have lead and wish to continue as a freelance programmer.
I promise you to keep both my BLOGS DotnetSizzler and Techbubbles interesting, up to date and informative. I thank you for your support and hope you will continue the same.
Be sure to check the DotnetSizzler and feel free to add your comments, suggestions and questions.
Share this post :
Related Posts:
No commentsMERGE Statement in SQL Server 2008
There has been significant T-SQL improvements in SQL Server 2008. This post explores the most notable changes in T-SQL introduced in SQL Server 2008.
The MERGE Statement
As name says, It combines Insert,Update, and Delete operations along with the Select operation which provides the source and target data for merge. In earlier versions, We need to write separate multiple statements to achieve the same.
Related Posts:
2 comments
