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

Overview of Business Intelligence(BI)

This will give an overview of Business Intelligence and Microsoft tools used for BI.
Pankaj Bajaj Jun 16, 2014
Primary Key in SQL Server

This blog defines primary key in SQL Server.
Rakesh Kalluri Jun 11, 2014
Exporting Excel Data to SQL using T-SQL

This blog defines how to export excel data to SQL using T-SQL.
Rakesh Kalluri Jun 10, 2014
Getting List of Tables in SQL Server

In this blog I demonstration on getting list of tables in SQL.
Abhijit Patil Jun 02, 2014
Constraints in C#

In this blog i will give demonstration on constraints in C#.
Abhijit Patil May 31, 2014
Save Text File in SQL Server

This blog defines how to save text file in SQL Server.
Abhijit Patil May 30, 2014
Passing Table as a Parameter to Stored Procedure

In this blog, I’m going to explain to you guys a very simple way to perform the procedure of passing table as a parameter to a Stored Procedure.
Sanjay Singh May 27, 2014
DB Backup using maintenance plan in SQL server 2012

In this blog we will learn how to create scheduled Data base backup using maintenance plan in SQL server 2012.
Khan Abrar Ahmed May 27, 2014
Introduction to Database in SQL Server

This blog defines database and the types of TSQL commands in SQL Server.
Abhijit Patil May 22, 2014
Ad Hoc Update to System Catalogs is not Supported in SQL Server 2012

This blog describes how to allow update to the system catalogs in SQL Server 2012.
Shivom Agarwal May 22, 2014
Create Encrypted View and Stored Procedure in SQL Server

This blog is to demonstrate .How to create Encrypted View and Stored Procedure in SQL to keep them safe(unchanged).
Anupam Singh May 20, 2014
Get SQL Objects Created Date on Modified Date

SQL objects created date or modified date.
Khan Abrar Ahmed May 15, 2014
Killing the Session in SQL Server

This blog defines how to kill the session in SQL Server.
Khan Abrar Ahmed May 15, 2014
Replace Last Charecter of the String in SQL Server

Replace last character of the string in SQL Server.
Khan Abrar Ahmed May 15, 2014
Column Reference in SQL Server

Column reference in SQL Server.
Khan Abrar Ahmed May 15, 2014
Executing DB Scripts using Batch File

This blog will provide the example to run the no. of scripts on SQL Server using bat file.
Khan Abrar Ahmed May 15, 2014
Transaction Handling in Insert Update Store Procedure in SQL Server

This blog will help to handle the transaction in Insert Update Stored Procedure.
Khan Abrar Ahmed May 15, 2014
Auditing SQL Server using LOGON Trigger

This blog is about creating a LOGON trigger in SQL for auditing purpose.
Anupam Singh May 14, 2014
Create Quick Copy of a Table in SQL Server

In this blog I am going to share a quick way to make a Copy of Table in SQL Server.
Anupam Singh May 13, 2014
How to Do Case Sensitive String Match in SQL server

While working on a SP today, I noticed that SQL Server does a case-insensitive string match in a query.
Nitesh Kejriwal May 13, 2014

661 - 680 of 1267

Learn SSRS In 11 Hours

Challenge yourself

SQL Server

E-Book Download

Get Certified

C# Advanced