increase column value

Question

Hibelow is Subsettable in databaseSubsetIdNameId1sara12jack2  SubsetId columns datatype is intand I have button in my page that I want  when I click on button it insert into SubsetId column last row values 1I mean  row with id2   SubsetId is 2when I click on button I want Row with id3  SubsetId be3gt21what should I write in SPBest Regards NEDA

kalpesh · Accepted Answer

You Must Check Maximum Value of Id Column and then Increament it by 1 Same for SubsetId column value whether you want it increament by Id column value or SusetId value by 1 CREATE PROCEDURE GetMaxID ASBEGINSELECT MaxID1 As ID  MaxID1 As SubsetId From SUBSETEND

increase column value

Company

Explore

Follow us

Contact Us

SubsetId	Name	Id
1	sara	1
2	jack	2