SQL Server Blogs

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.

Blogs

Difference Between Primary key, Unique key And Foreign Key

In this blog we will learn the basic differences between Primary key, Unique key and Foreign key. Difference between Primary key and Unique key.
Jaipal Reddy Jun 11, 2015
Import Comma Separated Data into Single Column

This blog describes how to get Comma Separated data from the table.
Gaurav Malviya Jun 09, 2015
SSRS Report Document Maps

This blog show how to use document maps for SSRS report.
Vijay Prativadi Jun 08, 2015
DDL, DML, DQL, DCL, TCL in SQL

In this blog we will learn a basic description about DDL, DML, DQL, DCL, TCL in Sql Server.
Jaipal Reddy May 30, 2015
System Databases in SQL Server

In this blog you will learn Master, Model, MSDB, TempDB in SQL Server.
Kiranteja Jallepalli May 29, 2015
How to Restrict Creating, Altering, Deleting Tables from a Database on specific date or on specif...

In this blog you will learn that How to Restrict Creating Altering Deleting Tables from a Database on Specific Date or on Specific Day using Trigger.
Debendra Dash May 13, 2015
SQL Server: Generate Report using PIVOT

In this blog we will learn how to Generate Report using PIVOT.
Rahul Kumar Saxena May 07, 2015
Inserting Record in Table using Stored Procedure

In this blog you will learn how to insert record in a table using a simple stored procedure.
Rovid Kashyap May 07, 2015
Extending DATEADD Function to Skip Weekend Days in TSQL

In this blog we will learn that how we can extend the date and skip a weekend Days in SQL.
Emiliano Musso May 07, 2015
Easiest way to JOIN Two or More SQL Tables

In this blog you will know the easiest way to join two or more SQL Tables.
Sabyasachi Mishra May 06, 2015
Encrypt and Decrypt Column Value In SQL Server Table

In this blog I am going to show how we can save our data in SQL Server Table in Encrypted form and how we can Decrypt our column value.
Rahul Kumar Saxena May 05, 2015
How to Make Join Query in SQL Server

In this blog you will learn how we can make a Join Query in SQL Server.
Isham Khan May 02, 2015
SQL Server Handle NULL value in Where Clause

In this blog you will learn that how to SQL Server Handle NULL value in Where Clause.
Rahul Kumar Saxena May 01, 2015
RESYNC SLAVE WITH MASTER SERVER IN MYSQL REPLICATION

In this blog you will learn about RESYNC SLAVE WITH MASTER SERVER IN MYSQL REPLICATION.
Akshay Phadke May 01, 2015
Copy and Paste One Table Record to Another Table

This blog is to describe how to copy and paste one table or its record to another table in SQL Server.
Debendra Dash Apr 30, 2015
How to delete duplicate records from a table leaving the original record

This blog explains how to delete all the duplicate records from the table leaving the original record.
Debendra Dash Apr 29, 2015
How To Change the Background color of SQL Server Query Editor and Font Color

In this blog we will learn to Change the Background color of SQL Server Query Editor and Font Color.
Debendra Dash Apr 26, 2015
Difference Between SP_rename and SP_renamedb in SQL Server

In this blog you will learn the difference between SP_rename and SP_renamedb in SQL Server.
Debendra Dash Apr 21, 2015
Retrieving a list of databases from SQL Server

In this blog we will Retrieve a list of databases from SQL Server.
Jignesh Trivedi Apr 13, 2015
Concat Fuction with null values in Sql Server

CONCAT is new T-SQL function feature in SQL Server 2012. It is used to concatenate the multiple values as a parameter separated by commas and return only a single string of parameter.
Naveen Kumar Apr 11, 2015

561 - 580 of 1267

Learn SSRS In 11 Hours

Challenge yourself

SQL Server

E-Book Download

Get Certified

Azure PaaS