How To- Check Primary Key Exists or not in Table

This is a simple tip post that may seem obvious and taken for granted for those of us who have been working with SQL Server for a while now but may be a newbie will find this helpful.

Here, I will give you a simple tip to check that primary is exists or not in table.

You can find some other articles and tips related to C#, ASP.Net and SQL Server in this blog.

How To- Get System Information using C#.

Here, I am going to explain you how to get the system information like OS information, Processor information etc using C#.

In my previous posts, I explained Hard drive information using C#, Create Directory/Folder using C#, Check Internet Connection using C#, SQL Server Database BackUp using C#, Partial Methods, Contextual Keyword, C# Static Methods and some other articles related to C#, ASP.Net and SQL Server .

For retrieving system information, we will use System.Management namespace.Using this namespace we can get lot of information about the system. For using this namespace follow the steps given below.

How To- Get hard drive information using C#

In this post, I will explain how to get the hard dive information of your system using C#.

In my previous posts, I explained Create Directory/Folder using C#, Check Internet Connection using C#, SQL Server Database BackUp using C#, Partial Methods, Contextual Keyword, C# Static Methods and some other articles related to C#, ASP.Net and SQL Server .

TO get the hard drive information first we need to add the following namespace.

ASP.Net- Creating Directory in C# | Creating Folder in C#

In this post, I will explain how to create , delete directory or folder using C#.

In my previous posts, I explained Check Internet Connection using C#, SQL Server Database BackUp using C#, Partial Methods, Contextual Keyword, C# Static Methods and some other articles related to C#, ASP.Net and SQL Server .

For creating, deleting directory using C#, First of all you will have to add the following namespace in your code file.

SQl Server- Reset Identity Column in SQL Server

If you deleted all the records from the table and there is an Identity column in your table, You will see that when you insert a new record in your table then Identity column value starts from the last value of that column incremented by your step value.

If you want to start the Identity column value from the seed value after deleting all the record then you must have reset the Identity column value. Here, I am going to show you that how you can reset Identity column value in SQL Server?.