Monday, 12 December 2022

How to insert into a table with just one IDENTITY column? SQL Server

 I have a table named Slider, Which stores my website's homepage slider image. So I need one column auto-increment identity field for the slider image record and the uploaded image will be renamed as the identity field value.

So I had to insert a row in a single-column auto increment field. I have achieved this by the query given below.

INSERT INTO [dbo].[Slider]  DEFAULT VALUES 

Next Topic

No comments:

Post a Comment