selvi jp

selvi jp

  • NA
  • 323
  • 77.3k

I want to multiple file record at a time with same id

May 12 2021 5:20 AM
This is my query.
CREATE TABLE [dbo].[ImageUpload](
    [Id] [int] IDENTITY(1,1) NOT NULL,
    [Title] [varchar](50) NULL,
    [Description] [varchar](100) NULL,
    [Place] [varchar](30) NULL,
    [Amount] [varchar](10) NULL,
    [ImagePath] [varchar](max) NULL,
    [ImageName] [varchar](100) NULL,
    [ImageType] [varchar](20) NULL,
    [UploadId] [int] NULL,
    [CreatedBy] [varchar](50) NULL,
    [CreatedDate] [date] NULL,
  TIMAGE_ON [PRIMARY]
GO
If i add multiple image then Upload id add same number like 5 image then 5 time add 1 in 5 rows .second time add 2 image then upload id insert 2 in 2 time ldd 2 in 2 rows.Like auto increment

Answers (1)