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...
This Blog to share my views, learning and experience on the SQL Server Reporting Services.