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

CASE Statement And Cursor

In this blog am explaining the relation between case statement in sql with some idea and work of Cursor.
Debendra Dash Apr 07, 2015
To Find nth value in SQL SERVER

How to find nth value from table in SQL SERVER
Gaurav Gupta Apr 06, 2015
Renaming a Database in SQL Server

In this blog you will learn Renaming a Database in SQL Server.
Debendra Dash Apr 05, 2015
Parameter-driven ASC/DESC Sort ( CASE in ORDER BY )

Sorting the result set ascending or descending order.
YOGEESHA NAIK Apr 01, 2015
Difference between Primary key and Foreign key

In this blog we will discuss about difference between primary key and foreign key of SQL Server.
Sanjib Barik Mar 30, 2015
Remove Duplicate record from a table using CTE

In this blog we will discuss how to remove duplicate record from a table using CTE. Without using TOP, MAX. There is a table name Employee and three columns like EmpId, EmpName, Salary.
Sanjib Barik Mar 30, 2015
Difference between Temporary table and Table variable

In this blog we will discuss about Difference between Temporary table and Table variable
Sanjib Barik Mar 30, 2015
Understanding Ranking Functions in Sql Server

In this blog I will explain the ranking functions in Sql server.
Akshay Phadke Mar 27, 2015
SQL Server: How to Clear User Objects from Master DB

This blog explains the ways to clear the user objects from Master Database in SQL Server.
Prakash Tripathi Mar 24, 2015
SQL ERROR 2012 VMWARE OS 2012

In this blog you will fin how To disable HotPlug capability using the vSphere Client.
Akshay Phadke Mar 24, 2015
Convert String to MD5 in SQL Server

In this blog we will see how to convert String to MD5 in SQL Server.
Nitin Mar 16, 2015
How to Insert Values in a Table with just an Identity Column

In this blog we will see how to insert values in a table with just an identity column.
Nitin Mar 14, 2015
Split FirstName and LastName from Full Name in SQL

This blog will show how to get firstname and lastname from Full name in SQL (assuming first space separates the full name).
Khargesh Rajput Mar 12, 2015
Solving SQL Server 2008 Access is Denied Error During Installation

In this blog we will learn how to solve "SQL Server 2008 Access is Denied Error" during Installation.
akshayp phadke Mar 12, 2015
How to format datetime & date in Sql Server 2005

In this blog you will learn about the all Date Time format using sql server.
Utkarsh Srivastava Mar 11, 2015
SQL Server: EXISTS Condition

This SQL Server blog explains how to use the EXISTS condition in SQL Server (Transact-SQL) with syntax and examples.
Pintoo Yadav Mar 11, 2015
Delete Duplicate Record Without Id by using CTE

In this blog we will learn deleting Duplicate Record without Id by using CTE Function.
Abrar Ahmad Ansari Mar 11, 2015
Insert Data from One Table to Other Table in Different Database

In this blog we will learn how to Insert Data from One Table to Other Table in Different Database.
Rahul Kumar Saxena Mar 11, 2015
Find missing Id in SQL Server through CTE

In this blogs we will learn how to find the missing id using CTE.
Abrar Ahmad Ansari Mar 11, 2015
Insert values to identity column in SQL Server

In this blog you will learn how to insert values to identity column in SQL Server.
Rahul Kumar Saxena Mar 09, 2015

581 - 600 of 1267

Learn SSRS In 11 Hours

Challenge yourself

SQL Server

E-Book Download

Get Certified

Kotlin