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?.

Blogger- Adding Facebook Like Box into Blogger Blog

Promoting your blog or web site, Facebook page is a great way. Facebook like box is a widely used social plugin from Facebook developers. Facebook like box helps your visitors to become a regular reader just by clicking a "Like" button. So this like box can increase number of your Facebook fans.

Here I will show you how you can add Facebook Like box into you blogger blog.

You can find some more articles related to Blogging, SQL Server , ASP.Net, C# and many more. To add the Facebook like box follow the below procedure.

SQL Server- Insert Values into Identity column

In my previous post Identity Column in SQL Server , I explained about Identity column and how you can create Identity column in table.In this post , I am going to show you that how you can insert values into Identity column.

In previous posts, I explained STUFF Function, LEN Function, UNICODE Function, LEFT Function, CHARINDEX Function, CHAR Function, ASCII Function, Simple script to backup all SQL Server databases, Table-Valued Parameters and some other articles related to SQL Server , ASP.Net, C#.

Creating Extension Method for Enumerated Type

In C#, you can extend the functionality of  Enumerated type by  using extension method same as for other types. Here , I will show you a simple example of creating extension method for Enumerated  type.

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 .

Below, I have created an extension method for DayofWeek enumarated type.

Check Internet Connection availability in ASP. Net

Here I will show you a simple tip for checking internet connection availability in ASP.Net using C#.

In my previous posts, I explained 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 check the internet connection availability in ASP.Net using C# , you have to write the following code-