SQL Server Articles

Post

SQL Server

Welcome to SQL Server section of C# Corner. In this section, you will find various SQL Server related source code samples, articles, tutorials, and tips.

Articles

Designing and creating a database in SQL Server 2005

This articles gives a picture around creating a database in SQL Server 2005 and some guidelines to put the log and data files.
Vijaya Kadiyala Aug 28, 2008
Database Files in SQL Server 2005

In this article, I would like to give you an overview of Database files in SQL Server 2005.
Vijaya Kadiyala Jul 10, 2008
Date type in RDBMS.

In this article I want to show you how to manipulate date data type in Microsoft SQL Server and Oracle database.
John Charles Olamendy Apr 29, 2008
Using SQL Server 2005 system SP to change extended property values of database objects

In this article, that is the logical continuation of the earlier published articles, I will show how you can update the value of an existing extended property or add a new extended property to a d...
Michael Livshitz Aug 01, 2007
Change SQL Server 2005 SA Password

This Article shows how to change the password of any account in SQL Server.
Nipun Tomar Mar 22, 2007
System Views and Functions in SQL Server 2005 by Steve on Jul 06, 2006

I tried to explore some basic TSQL functions and VIEWS in SQL Server 2005. I believe this would be useful when we write DDL-DML Statements.
Steve Jul 06, 2006
Introduction to Common Table Expressions – SQL Server 2005

This article delves into the concepts of Common Table Expressions (CTE) in SQL Server 2005 and their usage.
Dipal Choksi Aug 03, 2006