[Solved] How to auto increment a column without using Identity in SQL Server

I have a form having label Pid AND GIVE value against it in tetxtbox problem is this that i set Pid as primary key and every time i must enter unique value i want when i run the form value in textbox increment automatically and on submit button click it save in db