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

First Think of About Group by Query in SQL

In this blog we are learning what is a "Group by" query, how a "Group by" query works and the advantages and disadvantages of a "Group by".
Joginder Banger Dec 20, 2014
Find SQL Server Database Physical File Location

This Blog will show the physical location of all the database file in SQL Server.
Manish Kumar Choudhary Dec 20, 2014
SQL Error Concurrency Violation while Firing Update Command

This blog describe about SQL Error Concurrency Violation while Firing Update Command.
Shweta Lodha Dec 13, 2014
Last Backup for All Databases In SQL Server

This Blog will explain how to get the last back up data of all databases in SQL server.
Manish Kumar Choudhary Dec 12, 2014
Function To Convert Seconds to Hour: Minute: Seconds Format in Sql Server

This Blog will enplane about how to convert second into hours: Minute: seconds format by using function in sql server.
Manish Kumar Choudhary Dec 12, 2014
CHARINDEX Function in SQL Server

In this blog you will learn how to use the CHARINDEX function in SQL Server.
Rakesh Kalluri Dec 08, 2014
Make a Dynamic Pivot Table in SQL Server

This blog could solve your problem as I was faced this type of problem. So I share this code with you.
Joginder Banger Dec 03, 2014
SQL Server: Find Foreign Keys and Primary Key in a Table

In this blog you will learn how to find Foreign Keys and the Primary Key in a table in SQL.
Vamshi Krishna Nov 27, 2014
SQL Server - Max columns per primary key

This blog will teach you that making a primary key column has a limit in SQL-server and what can happen when user will exceed that limit.
Vamshi Krishna Nov 25, 2014
Cannot drop the database because it is being used for replication

Cannot drop the database because it is being used for replication from one server to another in SQL server 2008.
Sachin Kalia Nov 20, 2014
SQL Transaction Step by Step

In this blog, I will explain what is transaction, how to transaction work ,why we need transaction function and solve some basic error in Transaction.
Joginder Banger Nov 18, 2014
Calculate distance between two latitude longitude points in SQL Server

This blog calculate the distance between two latitude and longitude.
Manish Dwivedi Nov 11, 2014
How To Reset Identity Column Values In SQL Server

In this blog, you will learn how to reset an Identity Column Value in SQL Server.
Rakesh Kalluri Nov 01, 2014
Running .Sql File from Command Prompt

In this blog, I am demonstrating running the .sql files form the command prompt.
Rakesh Kalluri Oct 31, 2014
SQL SERVER Convert Table Data to XML Format using XML Path

Here I will explain how to convert table data to xml format in sql server or get table data in xml format in sql server. We can convert sql server table data in xml format by using XML PATH.
Digvijay Raghav Oct 28, 2014
Search by multiple parameter values without using dynamic SQL

This article will demonstrate how to use multi-value paramter in sql without using dynamic SQL.
Punit Jain Oct 19, 2014
How to Get Comma Separated values in SQL Server with STUFF and CROSS APPLY keywords

In this blog we will explore how to get comma delimited values in SQL Server
Swapnil Shah Sep 26, 2014
Sort (Order By) Data in SQL Except Some Certain Row

In this Blog I will tell you about how you can sort data in sql except some certain Row.
Anubhav Chaudhary Sep 11, 2014
How to get Comma Separated Values in SQL Server with 'Group By’ Facility?

This article describes how to get column values in one comma separated value in SQL Server.
Manish Kumar Choudhary Sep 09, 2014
How to Join table in SQL Server

In this blog you will learn about how to join table in SQL server.
Dipankar Biswas Sep 07, 2014

621 - 640 of 1267

Learn SSRS In 11 Hours

Challenge yourself

SQL Server

E-Book Download

Get Certified

EF Core