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

  • Rajeswari nathan

    Hidden Tables in SQL Server

    The tables "INSERTED" and "DELETED" are called magic tables of the SQL Server. We can not see these tables in the data base. But we can access these tables from the "TRIGGER"
    Rajeswari nathan Sep 25, 2009
  • Senthilkumar

    SQL Server 2005 features - Part I

    This article explains about the features in the sql server 2005 with example sql statements.
    Senthilkumar Sep 21, 2009
  • Senthilkumar

    Common Table Expression(CTE) in Sql server 2005

    This article explains about Common Table Expression(CTE) in sql server 2005 with sample sql queries.
    Senthilkumar Sep 15, 2009
  • Purushottam Rathore

    Stored Procedures vs parameterized queries

    I think StoredProcedures are better for maintainability because they can create a clear interface to the database
  • Purushottam Rathore

    Stored Procedures Related to Table in Database

    How to get all Stored Procedures Related to Table in Database?
  • Kapil Soni

    Take backup of sql server 2005 database through Management Studio

    This blog allow to take backup of your sql database....
    Kapil Soni Sep 01, 2009
  • Manish Dwivedi

    Get list of Stored Procedure and Tables from Sql Server database

    Here I will describe how to get list of Stored Procedure , Tables and views from Sql Server database
    Manish Dwivedi Jul 30, 2009
  • Nikhil Kumar

    How to create a SQL connectoin

    This blog shows you how to create a sql connetoin... by code.
    Nikhil Kumar Apr 20, 2009
  • Sateesh Arveti

    Look at SQL Server Native Client Programming

    SQL Server Native Client is a stand-alone data access API, used for both OLE DB and ODBC, that was introduced in SQL Server 2005.
    Sateesh Arveti Mar 16, 2009
  • Sateesh Arveti

    Usage of DBCC CHECKTABLE

    DBCC CHECKTABLE verifies the integrity of all the pages and structures that makes the table or indexed view.
    Sateesh Arveti Mar 03, 2009
  • Sateesh Arveti

    Usage of SHUTDOWN command

    SHUTDOWN command is used to shut down an SQL Server Instance.
    Sateesh Arveti Mar 01, 2009
  • Vijaya Kadiyala

    SQL Server 2005 Features Continues....

    SQL Server 2005 Features Continues....
    Vijaya Kadiyala Feb 27, 2009
  • Sateesh Arveti

    Usage of RESTORE HEADERONLY

    RESTORE HEADERONLY allows us to see all the backup information of a database backup.
    Sateesh Arveti Feb 27, 2009
  • Sateesh Arveti

    Usage of DBCC CHECKALLOC

    DBCC CHECKALLOC is used to check the consistency of disk space allocations structure for a specific database
    Sateesh Arveti Feb 26, 2009
  • Sateesh Arveti

    Importance of Replication Log Reader Agent

    Replication Log Reader Agent copies all transactions marked for replication from transaction log into distribution database.
    Sateesh Arveti Feb 25, 2009
  • Sateesh Arveti

    Look at SQL Server Fixed Database roles.

    SQL Server provides some built-in fixed database roles predefined in the database like db_owner ,db_securityadmin etc.
    Sateesh Arveti Feb 24, 2009
  • Sateesh Arveti

    Usage of DBCC FREESESSIONCACHE

    Use DBCC FREESESSIONCACHE command to clear distributed query connection Cache.
    Sateesh Arveti Feb 24, 2009
  • Vijaya Kadiyala

    One Cube

    Give Some & Get Some
    Vijaya Kadiyala Feb 22, 2009
  • Mahesh Chand

    SQL Server 2008 Express Download

    SQL Server 2008 Express version is available for download now - FREE. Very cool.
    Mahesh Chand Feb 17, 2009
  • Mahesh Chand

    SQL Server 2005 - Interesting Research and Reports

    In last couple of years, I have seen many medium to large scale businesses have started looking into SQL Server as an option to replace their existing Oracle databases.
    Mahesh Chand Feb 08, 2009
  • 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