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

Calculate the nth Largest Column Data in a Table

In this blog I shall demonstrate how to find the nth largest column data in a SQL Server table.
Praveen Raveendran Pillai May 09, 2014
Delete Duplicate Record from Table in SQL Server

Below query can help us to delete the duplication record from table using CTE.
Khan Abrar Ahmed May 08, 2014
Store Value in SQL Server Session

How to store value in SQL Server session and retrieve the value from SQL server Session.
Khan Abrar Ahmed May 08, 2014
Primary Key Vs Unique Key in SQL server

This blog is help us to what is difference between primary key and Unique key in SQL Server
Jignesh Trivedi May 07, 2014
Delete All Tables-Views-Stored Procedures in SQL Server

Delete all tables-views-stored procedures in SQL Server.
Bhupendra Singh May 06, 2014
CTE to Return all Items in Hierarchy

I have a table with a recursive hierarchy (i.e. ID, ParentID). For any item in this hierarchy, I want to be able to bring back a list of everything UP AND DOWN the hierarchy, along with the level f...
Bhupendra Singh May 01, 2014
Merging the Data of Two Tables in SQL Server

This blog defines the method of merging the data of two tables, in SQL Server.
sudipta sanyal Apr 28, 2014
Get Field List which is Set with A Default Value in a Database

In this blog, by using a script I want to display the field list, which is set with a default value in a database.
Shivom Agarwal Apr 28, 2014
How to replace html tags in string using a function

The below function explains how to remove html tags from string in SQL Server or how to parse html tags and retrieve only text from string in SQL Server without using regular expressions or remove ...
Ramasagar Pulidindi Apr 25, 2014
Datediff() Function to Show Date Difference in Days Hours Minutes

datediff() function in SQL Server to get date difference in days hours minutes, years, month between two dates or calculate datediff in SQL Server in days hours minutes format.
Ramasagar Pulidindi Apr 25, 2014
Get Stored Procedure Last Modified Date or Updated Date in SQL Server

how to get stored procedure last modified date in SQL server
Ramasagar Pulidindi Apr 25, 2014
Reset Identity Column Value to 1 in SQL Database

how to reset identity column value in SQL server or change or rest identity column value to 1 in SQL server.
Ramasagar Pulidindi Apr 25, 2014
How to Search/Filter Data from Table with Any Data/Empty/Custom data in SQL Sever 2008/2012 by St...

Many times i see that programmers confused with search data in the sql server table.Here i am describing for random data/full data/empty data transfer value from UI ,where data can search easily .I...
Dileep Kumar Patel Apr 24, 2014
SQL Aggregate Functions

This blog describes the aggregate functions in SQL.
Ranjit Powar Apr 24, 2014
How to Count Total Number of Stored Procedure and Tables in SQL Server 2008

Count total number of stored procedure, tables, Views and triggers in SQL Server 2008.
Deepak Porwal Apr 21, 2014
Select Unique Rows Based on Single Distinct Column

There is a situation when we need to retrieve only unique row based on one column. And also used join two tables to retrieve unique data. In this case we use distinct keyword to select unique recor...
Naveen Kumar Apr 17, 2014
Split Comma Separated Values in SQL Server

Split comma separated values in Sql Server using charindex function.
Pradip Pandey Apr 16, 2014
Update Multiple Data from 1 Table to Other Table in Single Query

Update multiple data from 1 table to other table in single Query.
Ashutosh Tripathi Apr 13, 2014
Difference b/w Union and Union All

Difference b/w union and union All in SQL Server.
Munesh Sharma Apr 07, 2014
Update Default Value of Column in SQL Server

This blog defines how to update default value of column in SQL Server.
Ashok Sharma Apr 02, 2014

681 - 700 of 1267

<<
33
34
35
36
37
>>

Learn SSRS In 11 Hours

Challenge yourself

E-Book Download