Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mihirpatel83
Starting Member
3 Posts |
 Posted - 2010-04-13 : 02:00:15
|
| I hv a table on server where in i have a field say TNO varchar2(10) which is auto-number with data T001, T002, T003 and so on...Now problem is when 2 user adds data 1 can insert and other gets error may b coz both read same data nd try 2 insert same record...How can i achieve this ?? is there any lock or smthing tat can help me or any kind of help will be appreciated.....Thanks in advance... |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-04-13 : 02:11:11
|
VARCHAR2 seems to be ORACLE.This is a forum for MS SQL Server.Maybe you can get a better help in a ORACLE forum.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
Sachin.Nand
2937 Posts |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
mihirpatel83
Starting Member
3 Posts |
Posted - 2010-04-13 : 04:46:57
|
| I am sorry as i wrote it by mistake....I am working on sql server only but i am learning oracle as well so i wrote that in hurry..Mihir Patel |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-04-13 : 04:58:50
|
...which is auto-number with data T001, T002, T003 and so on...I don't believe that in SQL Server
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2010-04-13 : 08:27:43
|
| How is the autonumbering implemented?Hopefully, using an identity column, in which case the solution will be simple.________________________________________________If it is not practically useful, then it is practically useless.________________________________________________ |
|
|
|
|
|
|
Issue Data insertion in a table by multiple user .