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

How To Set Up Database Mirroring In Windows Workgroup

How To Set Up Database Mirroring In Windows Workgroup In this tutorial i will teach you How To Set Up Database Mirroring In Windows Workgroup.Database mirroring is a solution for increasing the availability of a SQL Server database. Mirroring is implemented on a per-database basis and works only with databases that use the full recovery model.

How To Use Point In Time Recovery In SQL Server

How To Use Point In Time Recovery In SQL Server In this tutorial i will guide you through How To Use Point In Time Recovery In SQL Server.This is a very useful solutions.It will help you to restore your database at a specific point of time.But their are some limitations or you can say conditions for