Click here to Skip to main content
15,942,710 members
Home / Discussions / Database
   

Database

 
AnswerRe: datatype mapping Pin
Richard MacCutchan8-Jun-14 23:24
mveRichard MacCutchan8-Jun-14 23:24 
GeneralRe: datatype mapping Pin
Gilbert Consellado8-Jun-14 23:47
professionalGilbert Consellado8-Jun-14 23:47 
GeneralRe: datatype mapping Pin
Richard MacCutchan8-Jun-14 23:56
mveRichard MacCutchan8-Jun-14 23:56 
GeneralRe: datatype mapping Pin
Gilbert Consellado9-Jun-14 0:04
professionalGilbert Consellado9-Jun-14 0:04 
QuestionSQL Server and ADO.net IsolationLevel Pin
PIEBALDconsult6-Jun-14 16:10
mvePIEBALDconsult6-Jun-14 16:10 
AnswerRe: SQL Server and ADO.net IsolationLevel Pin
Eddy Vluggen6-Jun-14 23:05
professionalEddy Vluggen6-Jun-14 23:05 
GeneralRe: SQL Server and ADO.net IsolationLevel Pin
PIEBALDconsult7-Jun-14 4:39
mvePIEBALDconsult7-Jun-14 4:39 
QuestionHow to Sort this, Get Next Record ID when Many users inserting and different Districts Pin
Robymon5-Jun-14 23:03
Robymon5-Jun-14 23:03 
Rec_ID Rec_Name Dist_ID
1 A 1
2 B 1
1 AA 2
2 AB 2
3 C 2

How can i write a Insert sql script for this table, eg: i should insert Rec_ID 3 while inserting Record for Dist_ID 1 and also Rec_ID 4 for Dist_ID 2, Suppose if many users inserting from different places, how to handle this situation. what is the best method? I have following 2 ideas, which is right idea or is there any other method to implement this

1) Select Max(Rec_ID) for the district, suppose if 2 people inserting at the same time will be a issue.

2) Put a Lock in the Stored Procedure
SuggestionRe: How to Sort this, Get Next Record ID when Many users inserting and different Districts Pin
GuyThiebaut6-Jun-14 0:55
professionalGuyThiebaut6-Jun-14 0:55 
GeneralRe: How to Sort this, Get Next Record ID when Many users inserting and different Districts Pin
Robymon6-Jun-14 2:19
Robymon6-Jun-14 2:19 
GeneralRe: How to Sort this, Get Next Record ID when Many users inserting and different Districts Pin
GuyThiebaut6-Jun-14 2:24
professionalGuyThiebaut6-Jun-14 2:24 
GeneralRe: How to Sort this, Get Next Record ID when Many users inserting and different Districts Pin
ZurdoDev6-Jun-14 2:49
professionalZurdoDev6-Jun-14 2:49 
AnswerRe: How to Sort this, Get Next Record ID when Many users inserting and different Districts Pin
Eddy Vluggen6-Jun-14 2:36
professionalEddy Vluggen6-Jun-14 2:36 
AnswerRe: How to Sort this, Get Next Record ID when Many users inserting and different Districts Pin
PIEBALDconsult6-Jun-14 14:38
mvePIEBALDconsult6-Jun-14 14:38 
QuestionSQLite query Pin
David Crow5-Jun-14 10:38
David Crow5-Jun-14 10:38 
AnswerRe: SQLite query Pin
Mycroft Holmes5-Jun-14 12:47
professionalMycroft Holmes5-Jun-14 12:47 
GeneralRe: SQLite query Pin
David Crow5-Jun-14 17:38
David Crow5-Jun-14 17:38 
QuestionQuestion on Canidate keys and functional dependecies Pin
Member 108651294-Jun-14 16:35
Member 108651294-Jun-14 16:35 
AnswerRe: Question on Canidate keys and functional dependecies Pin
Eddy Vluggen5-Jun-14 8:05
professionalEddy Vluggen5-Jun-14 8:05 
AnswerRe: Question on Canidate keys and functional dependecies Pin
Eddy Vluggen6-Jun-14 23:39
professionalEddy Vluggen6-Jun-14 23:39 
QuestionIssue deploying SSIS Package in production web server Pin
Shuaib Kaniyar4-Jun-14 0:46
Shuaib Kaniyar4-Jun-14 0:46 
Question+ operaotor for outer joins in mysql. Pin
aghori3-Jun-14 19:55
aghori3-Jun-14 19:55 
AnswerRe: + operaotor for outer joins in mysql. Pin
Jörgen Andersson3-Jun-14 21:16
professionalJörgen Andersson3-Jun-14 21:16 
SuggestionData Mining Structure not Available in SSAS Tabular Model Pin
FLouis382-Jun-14 6:14
professionalFLouis382-Jun-14 6:14 
QuestionReady to give up on MySQL - is PostgreSQL better? Pin
Wombaticus1-Jun-14 22:09
Wombaticus1-Jun-14 22:09 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.