Skip to main content

Posts

Showing posts with the label Identity column in table

Identity Column in SQL Table

Identity Column in the SQL Table: How it works in SQL table? How Many Identity column can be created on the SQL table? How to insert user defined value in the Identity column? What will be the next value for the Identity column after the user defined value insertion in the table? Solution: Drop table #temp ; --Drop the temp table if it is already present Create table #temp --Create the temp table with identity column ( A int identity ( 1 , 1 ), --identity column --B int Identity(10,10), -- we can not create two identity column on a able C varchar ( 10 ) ) --insert values into table insert into #temp ( c ) values ( 'a' ) insert into #temp ( c ) values ( 'b' ) insert into #temp ( c ) values ( 'c' ) Select * from #temp --set identity insert on ont the table so that we can insert a user defined value in the identity column SET IDENTITY_INSERT #temp on insert into #temp ( A , C ) values ( 5 , 'd' ) --set ide...