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.

RECENT POSTS

  • Amin Anwar

    SQL Server

    What is Difference between SQL 2000 and 2005
    Amin Anwar Jan 27, 2009
  • Mahesh Chand

    SQL Server Data Services

    SQL Server Data Services, Microsoft's Cloud database, is SQL but not as you know it. Check what experts are saying about it.
    Mahesh Chand Jan 14, 2009
  • Shashi Ray

    How to delete the rows which are duplicate (don’t delete both duplicate records).?

    How to delete the rows which are duplicate (don’t delete both duplicate records).?
    Shashi Ray Sep 25, 2008
  • Abhishek Dhanotia

    Find Duplicate records from a Database Table and Delete them

    This blog is for finding Duplicate records from a table and delete it.
    Abhishek Dhanotia Sep 15, 2008
  • Abhishek Dhanotia

    Find Duplicate records from a Database Table and Delete them.

    Find Duplicate records from a Database Table and Delete them.
    Abhishek Dhanotia Sep 12, 2008
  • Sateesh Arveti

    A small note while converting a database from SQL Server 2000 to 2005 version

    A small note while converting a database from SQL Server 2000 to 2005 version
    Sateesh Arveti Sep 04, 2008
  • Bechir Bejaoui

    SQL Server 2008 Express edition is now available

    Finally, the SQL server 2008 express, the free version of the SQL server data base engine is available
    Bechir Bejaoui Sep 02, 2008
  • Vijaya Kadiyala

    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 27, 2008
  • prashant rathod
  • Nipun Tomar

    Enable Windows Search Service in Windows Server 2008

    Enable Windows Search Service in Windows Server 2008
    Nipun Tomar Aug 11, 2008
  • Raj Kumar

    Functions in SQL Server 2005

    In this article I am going to explain about some SQL Server 2005 functions with examples. Here are going to discuss about some string functions, numeric functions and date/time functions.
    Raj Kumar Aug 11, 2008
  • Manikandan S

    T-SQL XML Parser

    T-SQL Script which will parse the XML Formatted files
    Manikandan S Jul 22, 2008
  • Nipun Tomar

    Uninstalling Windows Internal Database

    It is not possible to remove this application with Add or Remove Programs, and it will not be uninstalled automatically when WSUS is uninstalled. If you wish to do so.
    Nipun Tomar Jul 21, 2008
  • Vijaya Kadiyala

    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 15, 2008
  • Scott Lysle

    Cascading Deletes in LINQ to SQL

    This article will discuss alternative methods for performing cascading deletes using LINQ to SQL. Cascading delete refers to the action of removing records associated by a foreign key relationship...
    Scott Lysle Jul 03, 2008
  • Sudheendra Desai

    Multiple Active Result Sets (MARS)

    This article gives you information about the Mars a feature supported by MSSqlServer 2005 and .Net 2.0/3.x, which is a feature to execute more than one query with one single connection to database.
    Sudheendra Desai Jun 03, 2008
  • siddharth sood

    Inner join

    Inner joins can happen between two tables which are in different database as well as different servers but the servers should be linked. Inner joins give matching records records from both tables.
    siddharth sood May 19, 2008
  • John Charles Olamendy

    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.
  • Mahesh Chand

    Intellisense in SQL Server

    I've been fond of ANTS Profiler for years now and I just downloaded SQL Prompt from RedGate Software. I have to admit, this is another tool I am liking a lot.
    Mahesh Chand Nov 20, 2007
  • Swetha Sankaran

    Windows Forms and SSIS package execution

    This shows us how to invoke SSIS packages by clicking a button in windows form.
    Swetha Sankaran Aug 15, 2007
  • Swetha Sankaran

    C#, BI, Sql server 2005 Developer.

    IT is so much fun. I blink my eye and there are hundered and one things to learn already which makes it all the more interesting. I love exploring new software. Learn new stuff. It is such a humbli...
    Swetha Sankaran Aug 15, 2007
  • Michael Livshitz

    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
  • Nipun Tomar

    Change SQL Server 2005 SA Password

    This Article shows how to change the password of any account in SQL Server.
    Nipun Tomar Mar 28, 2007
  • Steve

    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 Mar 15, 2007
  • Dipal Choksi

    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 Mar 15, 2007