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-

SQl Server- Identity Column in SQL Server

In this post, I will explain about the IDENTITY column into table in SQL Server.

In my 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. 

 

Identity Column

IDENTITY column is an auto incrementing column provided by SQL Server. SQL Server will take care of incrementing this column automatically.This is much like an AutoNumber field in Microsoft Access or a sequence in Oracle.

jQuery- Page Scroll to Top with jQuery | How to add Page Scroll to Top in web page

In some websites, you can see that when you scroll the page there is a link at the bottom of the page with text "Scroll to Top" and when you click on this link page moves to the top of the page. If you web page has lots of content, It is a very good idea to provide visitors within a easy way to quickly go to the top of the page.

In this article, we will create a page scrolling effect for returning to the top of the page using jQuery.

In previous posts, I explained Automatically Refresh Page Using Java Script , How to Create a Textarea Character Counter, Animated Sliding Recent Post Widget For Blogger, Change Input to Upper Case using Java Script, Calculate Age from Date of Birth Using Java Script, jQuery .toggleClass() example and some other articles related to jQuery, Java Script etc.