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.
AuthorKalyan Bandarupalli
My name is kalyan, I am a software architect and builds the applications using Microsoft .NET technologies. Here I am trying to share what I feel and what I think with whoever comes along wandering to Internet home of mine.I hope that this page and its contents will speak for me and that is the reason I am not going to say anything specially about my self here.
T-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.
Introducing 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...
MERGE 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...
Creating an Analysis Services Project in Visual Studio 2008
Microsoft SQL Server Analysis Services allows the developers to provide a unified access of data for analytical analysis and reporting. Developers can manage and aggregate the queries from multiple subject areas. This can be achieved by creating a cube in Visual Studio 2008. This post defines and explains the terms used in creating an analysis project in VS 2008.
Silverlight sample in Visual Studio 2008
This post explains the tools required to start working with the Silverlight 3 in VS 2008. Also explains the sample Silverlight application building in Visual Studio 2008 environment.
Table Expressions in SQL server
Table Expressions are sub-queries where a table is expected. There are two types of table expressions. This post explains how to use the Table expressions and their advantages.
Derived tables
Common Table Expressions
SQL server Joins or Subqueries?
Select statements that use join operator and join statements can be written in Subqueries and similarly Subqueries can be written in Joins. Writing the Select statements with Join operator can help database engine to find more efficient strategy for retrieving the appropriate data. However each having their own advantage over other. Some problems can be easily solve with Subqueries and some can...
SQL Server Reports Integration with SharePoint 2007
This post explains how to Deploy the SQL server Reports to Office SharePoint Server 2007. SQL Server Reporting Services can operate in two modes, either in Native Mode or Share Point Integration Mode.
Report Builder 2.0 in SQL Server 2008
Report builder 2.0 is a report authoring tool that we can use to design and publish reports. We can specify the data source, what data to display on report and which layout you prefer to see the report. When you run the report, the report processor takes all the information you specified and retrieves the data and generates each page as you view it. This post explains step-by-step details of...