Dear mentors,
This is my first posting here, though, i have learnt a lot from here.
I have a table "tblUserRequest" in sql server express 2005 database and vb.net 2008 application in front end. Table structure is the following: RequestID, UserID, RequestBody.
Users are submitting their queries in tblUserRequest. My question is what is the best policy to create RequestID? Shall i create new id from vb app then save all the data, or use stored procedure?
My objective is to ensure that no duplicate value is inserted. I don't want to use auto increment datatype.
Sorry for my poor language.
SKPaul