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

How to Trim all the Spaces from all Character Type Field of the Tables of the Database

How to trim all the spaces from all character type field of the tables of the database.
Amit Tiwari Jul 16, 2013
Reindexing and Reorganized in SQL Server 2008

Today I discuss Reindexing and Reorganized in SQL Server 2008.
Om Agarwal Jul 15, 2013
Convert Rows into comma separated using T-SQL

Convert Rows into comma separated using T-SQL
Riyaz Akhtar Jul 14, 2013
Find out the Owner of a Database and Change the Owner of a Database in SQL Server

Today I am determining the owner of the Database and change the owner of a database in SQL Server below given Query.
Om Agarwal Jul 12, 2013
New User Creation and Admin User Creation in SQL Server 2012

This blog defines new user creation and admin user creation in SQL Server.
Arun kumar Jul 11, 2013
How to Copy SQL Table into Excel and Other Formats

This blog defines how to copy SQL table into excel and other formats.
Arun kumar Jul 11, 2013
Create a New Jobs in SQL Server 2012

This blog defines how to create a new jobs in SQL Server.
Arun kumar Jul 11, 2013
Scheduling Auto Backup in SQL Server 2012

This blog defines scheduling auto backup in SQL Server 2012.
Arun kumar Jul 09, 2013
Current and Previous Week, Month, Quarter, Year in SQL Server

This blog defines current and previous Week, Month, Quarter, Year in SQL Server.
Gohil Jayendrasinh Jun 21, 2013
Different Like Operators in Stored Procedures in SQL Server

Here I am explaining four stored procedures to show use of different type of like in SQL Server.
Pankaj Pandey Jun 03, 2013
Change any keyword(variable) into all Stored Procedures in Two Steps

Change any keyword(variable) into all stored procedures in two steps.
Pankaj Pandey Jun 03, 2013
How to See Columns from SQL Server Query

How to see columns from sql server query.
Pankaj Pandey May 31, 2013
Compare Comma Separated Value with Comma Separated Column in SQL SERVER

How to compare two column values which are comma separated values.
Gaurav Gupta May 31, 2013
Compare single value with comma separated columns in SQL SERVER

How to compare single valued variable with comma separated values in a columns.
Gaurav Gupta May 30, 2013
How to use Switch-Case in Select SQL Server Query

Some times we need to apply switch case in sql query when we retrieved the data. At that time this blog may help you.
Pankaj Pandey May 30, 2013
Formula to Calculate the Range of an Integer Data Types in SQL Server

In this blog, I described how to calculate the maximum range of integer data types in SQL Server.
Rohatash Kumar May 28, 2013
Split Letter Of Word From String in SQL Server

Gets The first letter of each word separated by delimiter of string in SQL Server.
Kumar Sambhav May 22, 2013
Put Multiple Column Fields in Order by Syntax

Put multiple column fields in Order by syntax.
Pankaj Pandey May 10, 2013
Columnstore index in SQL server 2012

SQL Server 2012 introduced a new feature Columnstore Index which can be used to improve query performance. It is used in data warehousing.
Seema Chaudhary May 08, 2013
Show and insert data in linked server from mysql to SQL Server

Show and insert data in linked server from mysql to SQL server. Linked server created for using two database servers for one application, like my sql and sqlserver.
Pankaj Pandey May 03, 2013

801 - 820 of 1267

Learn SSRS In 11 Hours

Challenge yourself

SQL Server

E-Book Download

Get Certified

Python