SQL Server
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

  • Saddamhusen Uadanwala

    Download file(s) from FTP Server using FTP Command through SQL Server

    Just use FPT Commands to Fast download and upload files in SQL Server.
  • Raj Kumar

    A network-related or instance-specific error occurred while establishing a connection to SQL Server

    In this blog, you will learn how to resolve this error in SQL Server 2014. "A network-related or instance-specific error occurred while establishing a connection to SQL Server"
    Raj Kumar Sep 28, 2016
  • Saddamhusen Uadanwala

    Creating Query Shortcuts in SQL Server Management Studio

    Create own Query Shortcuts in SQL Server Management Studio to work fast and flexible.
  • Yadagiri Reddy

    Generating Scripts in SQL Server

    This article explains how to generate the scripts in SQL Server.
    Yadagiri Reddy Sep 19, 2016
  • Pankaj  Kumar Choudhary

    Shortcut Key To Get The All Table Related Information

    In this blog, we learn, how to get all table related information, using shortcut key.
  • Andrew Jackson

    Steps to Perform Page Level Restore Operations In SQL Server

    This blog is about applying page level restore operations in SQL Server database and understanding its advantages and how useful it is.
    Andrew Jackson Sep 07, 2016
  • Ritesh Singh

    SQL Server Performance Tuning

    In this blog I will explain about SQL Server performance tuning tips.
    Ritesh Singh Sep 07, 2016
  • Bikesh Srivastava

    Create Backup (.BAK) File Of SQL Database Using SQL Server Job Agent

    In this article, you will learn simple steps to create backup files of SQL database, using SQL JOB.
    Bikesh Srivastava Sep 06, 2016
  • Tapan Patel

    Querying SQL Constraints

    Querying constraints using system query.
    Tapan Patel Sep 02, 2016
  • Tapan Patel

    Querying SQL Object Properties

    Below are some query example where you can actually look through column metadata that gives you information regarding whether the column is identity, if it allows null or not and so on.
    Tapan Patel Sep 02, 2016
  • Tapan Patel

    Querying SQL Objects

    For each object which is schema scoped, SQL server identifies that object using the object id. If queried for objects like trigger (which is not schema scoped) or the objects which are not there in...
    Tapan Patel Sep 02, 2016
  • Pankaj  Kumar Choudhary

    Difference b/w GETDATE And SYSDATETIME Function In SQL Server

    In this blog, we will learn the difference b/w GETDATE and SYSDATETIME function in SQL Server.
  • Dharmesh Singh

    Decimal To Binary Conversion In SQL Server

    This code is for decimal to Binary conversion in SQL Server.
    Dharmesh Singh Aug 27, 2016
  • Ashish Srivastava

    First Name + Middle Name + Last Name Merge With One Extra Space

    This code is for first Name + Middle Name + last name merge with one extra space.
    Ashish Srivastava Aug 27, 2016
  • Rakesh Dabde

    2nd Highest Salary in SQL Server

    This code is to find Second highest Salary from table in Sql server.
    Rakesh Dabde Aug 26, 2016
  • Pankaj  Kumar Choudhary

    SQL Server Performance Tuning Tips

    In this article, you will learn the tips of fine tuning the performance of SQL Server.
  • Padmanaban Pugalenthi

    Set The Gridview's Datasource Property And Simply Call The Databind Method

    This code is for set the GridView's Datasource property and simply call the DataBind method.
  • ketan borsdiya

    Store And Retrive Hierarchical Data In SQL

    This code is for Store and retrive hierarchical data in SQL.
    ketan borsdiya Aug 25, 2016
  • Vandana  Blogs

    Month Wise Yearly Data With SQL Server

    Here we will find Total Amount Since starting year to Today's Date Monthly Report with corresponding Year with sql server and get total of the amount at the footer of gridview.
    Vandana Blogs Aug 25, 2016
  • Ashish Srivastava

    SQL Function Get Total Time in HH:MM:SS

    This code is for SQL Function Get Total Time in HH:MM:SS.
    Ashish Srivastava Aug 25, 2016
  • Nikhil Sangani

    Find All Stored Procedures Containing Text In SQL SERVER

    Here I will explain how to find stored procedures name which contain search text.
    Nikhil Sangani Aug 25, 2016
  • Ramesh Singh

    Find the Missing Sequential Number From Table

    Find the Missing Sequential Number From Table
    Ramesh Singh Aug 25, 2016
  • Dharmesh Singh

    Forcefully Rename Or Delete Database

    This code snippet is for Forcefully Rename or Delete Database.
    Dharmesh Singh Aug 25, 2016
  • Midhun T P

    Updating A Table Using Inner Join In SQL

    Using Inner join to update a table.
    Midhun T P Aug 24, 2016
  • Dharmesh Singh

    SQL Server Stored Procedure to Compress Tables

    SQL Server Stored Procedure to compress tables.
    Dharmesh Singh Aug 24, 2016
  • View More