In this article, we will see how to countrows in table andthe largest row table in database in Transact-SQL..

In this article we learn how to get space-used information on database objects. Sp_spaceused procedure ensures getting space-used information to us.

In this article we will learn how to use DATEADD system function. Sometimes we need to get new datetime values from existing date records.

In this article you will learn about string functions in SQL Server. This is Part One of the series.

In this article we will learn how to create view with T-SQL codes. Views, virtual tables represent of one or more table data at one time.

In this article we will learn how to use ROW_NUMBER() function and doing filter work by using it.

In this article you will learn how to perform various calculations using SELECT Statement.

In this article you will learn about ORDER BY clause. ORDER BY clause is use to display data in an ordered way.

In this article we will learn how to use pivot in T-SQL to convert rows into columns.