Blog

Time and Date Formats

We can display the date and time data in many different formats using the CONVERT function with different styles.

By Admin

The Row Number Function

Being a web developer, you may often need to generate sequential numbers for listing pages. When using SQL server 2000, you may find it quite hard to implement this. Fortunately, Microsoft has introduced a handy ranking function Row_Number () in TSQL 2005. It cuts out a significant amount of the effort needed for sequential number generation using SQL queries.

By Admin

SQL Queries

The real power and advantage of having a database is not only to store information, but also the capability to retrieve and report on the stored data. A query is simply a question you ask the database to help locate specific information. It is the ability to request information from the database by combining data from multiple tables and retrieving data based on specified conditions.

By Admin

T-SQL Programmability Features in SQL server 2008 - Part 1

Microsoft SQL Server 2008 introduces several important new Transact SQL programmability features and enhances some existing ones. SQL Server 2008 provides a comprehensive data platform that is more secure, reliable, manageable and scalable for your mission critical applications. It enables developers to create new applications that can store and consume any type of data on any device, and enables all your users to make informed decisions with relevant insights.

By Admin

SQL Joins, Inner Join, Left Join, Right Join, Full Join

SQL Joins are used to query data from two or more tables, based on the relationship between columns in the tables. Join condition defines the way two tables are related in a query by:

By Admin