very very big problem
Dear friends I have one table having columns date and serial no. I want to generate sr no when date changes.its datatypes are datetime and int in sql server. and i am sending parameter through date time picker
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Suthish NairPosted Dec 9, 2010, 10:51 PM
Hope your query got resolved or let us know...
Mayur GujrathiPosted Dec 9, 2010, 10:39 PM
Suthish NairPosted Dec 9, 2010, 2:19 PM
Typing such a subject line is not acceptable. Next time, please take care.
Set sr no as Primary Key.
Set as IsIndentity to Yes
Set Indentityincrement by 1
Mamta MPosted Dec 9, 2010, 4:04 AM