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

Useful SQL Queries

In this article, we'll learn some basic but useful SQL queries.
Pankaj Kumar Choudhary Feb 21, 2016
Using CLR With SQL Server 2012

In this article, I’ll cover the SQL CLR in SQL Server 2012.
Vidya Vrat Agarwal Dec 08, 2013
Create Your First CLR Trigger in SQL Server 2008 Using C#

CLR Trigger for SQL Server. Here you will see how to create your first CLR Trigger for SQL Server 2008 using C#.
Vishal Nayan May 05, 2011
How to use RowCount in SSIS

RowCount in SSIS. Here you will see how to use RowCount in SSIS.
Muralidharan Deenathayalan May 19, 2011
A Simple Use of Case Statement in SQL Server 2012

This article will give you an idea of how to use a Case expression in SQL Server.
Rohatash Kumar Oct 09, 2012
How to Create Database Backup in SQL Server 2012

In this article, I am going to explain how to create a database backup in SQL Server 2012.
Vipendra Verma Aug 17, 2012
Data Encryption and Decryption in SQL Server 2008

Cryptography can be implemented in the SQL Server. This article explains about the encryption and decryption of data in SQL Server.
Srihari Chinna Nov 09, 2010
Using Case With Select and Update Statement in SQL Server 2012

In this article, I would like to show the most commonly used case expressions with update statements in SQL Server.
Rohatash Kumar Nov 05, 2012
Passing Table Valued Parameter to Stored Procedure: Part 2

Here you will see how to pass a table valued parameter to a Stored Procedure.
Pradeep Chandraker Jun 16, 2011
Passing Table Valued Parameter to Stored Procedure: Part 1

In this demonstration I am taking simple scenario, where I will to pass customers information to stored proc and insert customer rows into database.
Pradeep Chandraker Jun 16, 2011
Passing DataTable to StoredProcedure as Parameter in C#

This article describes how to pass a DataTable to a Stored Procedure as a parameter using ADO.NET in C#.
Kailash Chandra Behera Mar 28, 2015
Convert Rows to Columns in SQL Server

This article will help to convert values in rows to column/fields name or headers.
Suthish Nair May 29, 2011
Clustered Index and Non-Clustered Index in SQL Server

Here we are going to discuss clustered and non-clustered indexes in SQL Server.
Nipun Tomar Apr 12, 2011
SQL Database Mail Profile Name is Not Valid in SQL Server 2012

This article explains how to send emails using the msdb.dbo.sp_send_dbmail Stored Procedure as a non-sysadmin user in SQL Server 2012.
Shivom Agarwal May 16, 2014
Joining Three or More Tables in SQL Server 2012

This article will give you an idea of how to join three or more tables and also defines the join in SQL Server.
Rohatash Kumar Jan 03, 2013
Query Optimization in SQL Server

This article offers suggestions on how to optimize query performance in SQL Server 2005.
John Charles Olamendy Dec 19, 2007
Delete Duplicate Records Using CTE

In this article we will see how to delete duplicate records from a table using CTE. But first let us see what CTE is.
Nitin Apr 17, 2015
Removing the First and Last Character From a Table Column in SQL Server 2012

In this article I provide a quick overview of the various Queries to remove the first and last character from a string in SQL Server.
Rohatash Kumar Nov 23, 2012
Store and Retrieve Image in Crystal Reports From SQL Database and Folder Using ASP.Net

Here, we will see how to store and retrieve an image in Crystal Reports from SQL Database and folder using ASP.Net.
Saineshwar Bageri Jan 21, 2014
Creating and Managing User Defined Functions in SQL Server 2008

Here you will see how to Create and manage User Defined Functions in SQL Server 2008.
Vishal Nayan Sep 02, 2011

761 - 780 of 1689

<<
37
38
39
40
41
>>

Learn SSRS In 11 Hours

Challenge yourself

E-Book Download