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 DATENAME and DATEPART in SQL SERVER

This blog describes what is the difference between Datename() and Datepart() function in SQL SERVER.
Manas Mohapatra Aug 12, 2015
Calculate Row Size of a Table in SQLServer

This Blog will describe how to calculate row size of a table in SQL Server.
Manas Mohapatra Jul 28, 2015
Languages Supported by SQL Server

In this blog, I am going to explain the languages supported by SQL Server.
Debendra Dash Jul 18, 2015
Format Function in SQL Server 2012

In this blog you will learn how to format function in SQL Server 2012.
Rakesh Kalluri Jul 14, 2015
Split String of Records and insert into Table in SQL Server

In this blog, I will show you how to split string of records and insert into table in SQL Server.
Govinda Rajulu Yemineni Jul 13, 2015
Why We Need Self Join in SQL

In this blog we will learn about the Self Join in SQL.
Gaurav Kumar Jul 10, 2015
Connecting to SQL Azure via the SQL Server Management Studio

This article explains how to connect to SQL Azure via the SQL Server Management Studio (SSMS).
Narasimha Reddy Chennupalli Jul 06, 2015
Get a list of tables used in Procedures, Procedures used by Table

In this blog, I have explained how to get a list of tables used in Procedures vice versa.
Jaipal Reddy Jul 03, 2015
Date Function with ISNULL and between Operator in SQL Server

Here we will discuss Date Function with ISNULL and Between Operator in SQL Server.
Jaipal Reddy Jun 23, 2015
Optional parameters in SQL Server Stored Procedures

In this blog you will learn how to create and use optional parameters in SQL Server stored procedures.
Jaipal Reddy Jun 22, 2015
Alter the Table Columns without Dropping it

In this blog explains Ways to prevent Saving changes is not permitted in SQL Server.
Jaipal Reddy Jun 16, 2015
INSERT Multiple Records with a Single INSERT Statement in SQL Server

In this blog you will learn how to INSERT Multiple Records with a single INSERT statement in SQL Server.
Jaipal Reddy Jun 15, 2015
Insert Records using SELECT and UNION ALL Statements in SQL

In this blog you will learn how to insert data using SELECT and UNION ALL statements in SQL language.
Jaipal Reddy Jun 15, 2015
Differences between STUFF, REPLACE and SUBSTRING in SQL Server

In this blog you will learn the basic differences between STUFF, REPLACE and SUBSTRING in SQL Server.
Jaipal Reddy Jun 13, 2015
Difference between Stored Procedure and Function

In this blog you will learn the basic differences between Stored Procedure and Function.
Jaipal Reddy Jun 13, 2015
Differences between Clustered Index and NonClustered Index

In this blog you will learn the basic differences between Clustered and NonClustered Index.
Jaipal Reddy Jun 13, 2015
Differences Between UNION And UNION ALL Operators In SQL Server

In this blog you will learn the basic differences between UNION and UNION ALL Operators in SQL Server.
Jaipal Reddy Jun 13, 2015
Difference between WHERE and HAVING clause in SQL Server

In this blog you will learn the basic difference between WHERE and HAVING clause in SQL Server.
Jaipal Reddy Jun 13, 2015
Difference between TRUNCATE and DELETE in SQL

In this blog, you will learn the difference between TRUNCATE, DELETE and DROP SQL commands.
Jaipal Reddy Jun 12, 2015
Get Row Count including Column Values in SQL Server

In this blog we will learn about how to Get Row Count including Column Values in SQL Server.
Rahul Kumar Saxena Jun 11, 2015

541 - 560 of 1267

Learn SSRS In 11 Hours

Challenge yourself

SQL Server

E-Book Download

Get Certified

Java Developer