Category Archives: Sql Server

SQL Server Tutorials, SQL Server Tutorials for Beginners, SQL Server Online Course, Microsoft SQL Server Learning, Microsoft Online Learing

How To Insert Values Into An Identity Column In SQL Server

How To Insert Values Into An Identity Column In SQL Server In this tutorial i will explain you How To Insert Values Into An Identity Column In SQL Server.Identity columns are mostly used as primary keys in tables.These columns automatically assign a value for each new row.But if you want to insert your own value into the

How To Backup All Database In SQL Server Which Are Online

How To Backup All Database In SQL Server Which Are Online In this tutorial i will explain How To Backup All Database In SQL Server Which Are Online.We are using CURSOR to achieve this.Cursor is a database object used by applications to manipulate data in a set on a row-by-row basis. Script: DECLARE @name VARCHAR(50) — database name DECLARE @path

What Is Function In SQL Server and How To Use It

What Is Function In SQL Server and How To Use It In this tutorial i will let you know What Is Function In SQL Server and How To Use It.Function is a Transact-SQL or common language runtime (CLR) routine that accepts parameters, performs an action, and returns the resulte.The return value can either be a

Difference Between Primary Key and Unique Key

Difference Between Primary Key and Unique Key In this post we will see the Difference Between Primary Key and Unique Key.Primary key and Unique key which seems to be identical, but they are different in features and behavior.We already discussed on our earlier post about Primary key & Unique Key. Difference between Primary key and Unique key: Primary

Difference Between Primary Key and Foreign Key

Difference Between Primary Key and Foreign Key In this post we will see the Difference Between Primary Key and Foreign Key.Primary key and foreign key which seems to be identical, but they are different in features and behavior.We already discussed on our earlier post about Primary key & Foreign Key. Difference between Primary key and Foreign

Connection String In Asp.Net When Database Mirroring Is Configured

Connection String In Asp.Net When Database Mirroring Is Configured In this tutorial i will let you know about how to configure Connection String In Asp.Net When Database Mirroring Is Configured.Database Mirroring which we are using for High availability and in my opinion it is better then Log-Shipping. We already discussed about Database Mirroring and how to