If there is a table with identity key column, can we insert value in that column explicitly? If yes then how



SET IDENTITY_INSERT Test ON Insert Into Test(Id, Name) Values (1, ‘Amit’) SET IDENTITY_INSERT Test OFF




Share this article \| Print \| Article read by 1078 times
Author: Guest Guest user is that user who have done some activity on website without login. Activity contains commenting on any article, uploading an image on website etc.	Related Articles: Create an index with Drop existing index on tab... Create queries of database tables with its data... How to check that sql instance is running on PC... Add Day, Month or Year in date column in sql se... Index in SQL... SET ANSI_NULLS explanation... Cascading referential integrity in sql server... Related Interview Questions: Create an index with Drop existing index on tab... Create queries of database tables with its data... How to check that sql instance is running on PC... Add Day, Month or Year in date column in sql se... Index in SQL... SET ANSI_NULLS explanation... Cascading referential integrity in sql server... What is the difference between temporary table ... .NET and SQL Server interview questions - Can y... .NET and SQl Server interview questions :- Test... .NET and SQL Server interview questions -Show P... SQL Server interview questions: - Elaborate two... SQL Server interview question:- Mention SSIS, S...