Here, I have provided an article showing you how to create a user-defined type and rules in SQL Server.

In this article I described encryption of a view in SQL Server.

In this article I described indexes in SQL Server.

In this article I described functions in SQL Server.

In this article I described encryption of Stored Procedures in SQL Server.

This article contains the most commonly used global variables in SQL Server under a single article with examples.

Here, we will see use of Object Explorer to identify dependencies before changing or deleting an object or table.

In this article, I would like to show the new built-in function IIF in SQL Server. IIF is a shorthand way for writing a CASE statement.

In this article, you will see some of the SQL Server System functions which provide information about database objects.

Here, I have provided an article showing you how to utilize the two new logical functions Choose and IIF in SQL Server.

This article demonstrates how to generate script in SQL Server database.

In this article, we covered system date and time in-built functions such as Sysdatetime, Sysdatetimeoffset, Sysutcdatetime, Getdate etc that returns the current date and time from the SQL Server.

Here, you will see how to use mathematical numeric functions in SQL Server, including how to round values.

Developers have struggled with the power and limitations of SQL. SQL is language oriented to manipulate data set, but enterprise applications always need to implement business logic that goes beyon...

In this article I will explain how you can use such a T-SQL (SQL Server 2005) feature as OUTPUT clause in order to get information about rows, which were affected, when deleting process is executed...

This article is intended to illustrate how to use triggers in databases systems to enforce business rules and react to events in database applications thus supporting the Active databases principles.

Enabling search in membership profile properties using SQLSERVER2005 pluggable assembly created by C#.

Here, you will see the DateName function that represents the specified datepart of the specified date such as day, month, year, quarter, hour, minute in SQL Server.

In this article, let us see how to use the 7 new builtin DateTime functions of Microsoft SQL Server 2012 Release Candidate 0 with their syntax and sample queries.

This article will show how to start, stop and restart the database engine in SQL Server 2005.