Tuesday, April 5, 2011

How to insert a value of single Identity column

Insert into Table name [default values] eg-- suppose i have a table name pp and which have 1 columnid which is identity and i want to insert a value through insert clause then use following syntax. insert into pp default values and values insert to the column. thanks.