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

Row Constructor in SQL Server

Row constructor in SQL Server.
Abhay Shanker Dec 29, 2013
Concatenate Columns in SQLServer

Explains that how to Concatenate columns in SQLServer.
Abhay Shanker Dec 26, 2013
Get List of all parameters of an SQL Server Store Procedure

Script to get the list of all the parameters of an SQL Server Store Procedure.
Abhay Shanker Dec 19, 2013
Parent-Child Recursive Query using CTE

This blog defines parent-child recursive Query using CTE.
Preet Singh Dec 13, 2013
Remove a Column from SQL Server Table

Remove a column from SQL SERVER database table.
Abhay Shanker Dec 10, 2013
Change the Data Type of a Column in SQL Server

This blog explains how to change the data type of a column with the minimum possibility of existing data loss.
Abhay Shanker Dec 09, 2013
Rename a Column in SQL Sever

Sometimes it happens that we misspell the column name or wish to rename the column. We can do so by following the steps in this post.
Abhay Shanker Dec 07, 2013
Export SQL Table Data in Excel

In this post I would like to show you the method of exporting data from SQL table to Excel.
Priti Kumari Dec 05, 2013
How to Delete Duplicate Row from Database Table in SQL server

In this post I would like to define the method of deleting the duplicate row from the database table.
Priti Kumari Dec 05, 2013
How to use Self Join in SQL Server

SELF JOIN for use same table join, in some business logic want some result by same table but with condition that time we use this.
Gaurav Malviya Dec 03, 2013
How to Get Trim String in SQL Server

Here, I created user function it called TRIM for us for get trim string.
Gaurav Malviya Dec 03, 2013
Insert Bulk Row at a Time in SQL Table from C# Code

In this blog you will learn how to Insert the bulk data at a time in an SQL table.
Priti Kumari Dec 03, 2013
Check String Against SQL Injection in C#

Here I have to show an example on how to restrict the SQL injection.
Priti Kumari Dec 02, 2013
Knowing and Removing the Underscore Records in a table

In this blog we will know how to find and remove the underscore records in a table.
Satyapriya Nayak Nov 29, 2013
Displaying Row number without using Row_number Function in SQL Server

Displaying Row number without using Row_number function in SQL Server.
Devesh Omar Nov 21, 2013
Return a New IDENTITY Column Value

In this blog I will explain how to return identity column value in SQL Server.
Nitin Bhardwaj Nov 19, 2013
Selecting the Top Records from the SQL Server without using the TOP keyword

Selecting the top records from the SQL Server without using the TOP keyword.
Devesh Omar Nov 15, 2013
Ways to Get N th Largest Salary in SQL Server

Ways to get N th largest salary in SQL Server.
Devesh Omar Nov 13, 2013
Ways to Find and Deleting Duplicate Records in SQL Server

Ways to find and deleting Duplicate records in SQL Server.
Devesh Omar Nov 13, 2013
SQL Query to Search a Column Name in all Tables

This query will give you column name in all tables,Sps,etc. just give your column name in place of employee and see the magic.
Basappa Patil Nov 13, 2013

741 - 760 of 1267

Learn SSRS In 11 Hours

Challenge yourself

SQL Server

E-Book Download

Get Certified

Python