Click here to Skip to main content
15,884,353 members
Home / Discussions / Database
   

Database

 
GeneralRe: Join or the nomemclature for join using EF in c# Pin
Richard Deeming30-Nov-16 2:10
mveRichard Deeming30-Nov-16 2:10 
GeneralRe: Join or the nomemclature for join using EF in c# Pin
indian1436-Dec-16 11:43
indian1436-Dec-16 11:43 
GeneralRe: Join or the nomemclature for join using EF in c# Pin
jkirkerx6-Dec-16 12:08
professionaljkirkerx6-Dec-16 12:08 
GeneralRe: Join or the nomemclature for join using EF in c# Pin
indian1436-Dec-16 14:11
indian1436-Dec-16 14:11 
GeneralRe: Join or the nomemclature for join using EF in c# Pin
jkirkerx7-Dec-16 6:58
professionaljkirkerx7-Dec-16 6:58 
QuestionRecommendations on nosql for embedded Pin
LasseL28-Nov-16 4:04
LasseL28-Nov-16 4:04 
AnswerRe: Recommendations on nosql for embedded Pin
Afzaal Ahmad Zeeshan29-Nov-16 9:22
professionalAfzaal Ahmad Zeeshan29-Nov-16 9:22 
QuestionMySQL Pin
Mycroft Holmes24-Nov-16 20:39
professionalMycroft Holmes24-Nov-16 20:39 
I've been faffing around with MariaDB with the view to converting our SQL Server Apps. First step is to convert out CRUD code generator. I'm used to SQL Server which insists that I prefix a parameter value with @ MySQL has no such rule and you can end up with something like
SQL
select *
from vwTestMAF
where TestMAFID = -1 or  TestMAFID = TestMAFID;
where the TestMAFID is both the field name and the parameter name and the query naturally does not work.

Is there a naming convention for MySQL parameter (prefixing the parameter name with @ did not work either!)
Never underestimate the power of human stupidity
RAH

AnswerRe: MySQL Pin
Midi_Mick24-Nov-16 21:10
professionalMidi_Mick24-Nov-16 21:10 
GeneralRe: MySQL Pin
Mycroft Holmes25-Nov-16 22:13
professionalMycroft Holmes25-Nov-16 22:13 
AnswerRe: MySQL Pin
Michael_Davies24-Nov-16 21:35
Michael_Davies24-Nov-16 21:35 
QuestionWhat are some tricky/interesting SQL questions you were asked in interviews? Pin
qptopm20-Nov-16 21:52
qptopm20-Nov-16 21:52 
AnswerRe: What are some tricky/interesting SQL questions you were asked in interviews? Pin
Afzaal Ahmad Zeeshan20-Nov-16 23:49
professionalAfzaal Ahmad Zeeshan20-Nov-16 23:49 
AnswerRe: What are some tricky/interesting SQL questions you were asked in interviews? Pin
Simon_Whale21-Nov-16 0:27
Simon_Whale21-Nov-16 0:27 
AnswerRe: What are some tricky/interesting SQL questions you were asked in interviews? Pin
Eddy Vluggen21-Nov-16 1:12
professionalEddy Vluggen21-Nov-16 1:12 
QuestionError??? Pin
Member 1116162519-Nov-16 17:28
Member 1116162519-Nov-16 17:28 
AnswerRe: Error??? Pin
Afzaal Ahmad Zeeshan20-Nov-16 9:38
professionalAfzaal Ahmad Zeeshan20-Nov-16 9:38 
AnswerRe: Error??? Pin
Daniel Jones19-Dec-16 17:42
Daniel Jones19-Dec-16 17:42 
QuestionMySql 1093 Error: You can't specify target table 'c1' for update in FROM clause Pin
Abhinav_00717-Nov-16 13:16
Abhinav_00717-Nov-16 13:16 
AnswerRe: MySql 1093 Error: You can't specify target table 'c1' for update in FROM clause Pin
Afzaal Ahmad Zeeshan20-Nov-16 23:51
professionalAfzaal Ahmad Zeeshan20-Nov-16 23:51 
QuestionMessage Closed Pin
11-Nov-16 11:33
Jassim Rahma11-Nov-16 11:33 
SuggestionOT: Your signature... Pin
Kornfeld Eliyahu Peter12-Nov-16 21:36
professionalKornfeld Eliyahu Peter12-Nov-16 21:36 
GeneralRe: OT: Your signature... Pin
Mycroft Holmes12-Nov-16 21:48
professionalMycroft Holmes12-Nov-16 21:48 
AnswerRe: [MySQL] How to SELECT direct and indirect staff Pin
Jörgen Andersson12-Nov-16 23:56
professionalJörgen Andersson12-Nov-16 23:56 
GeneralRe: [MySQL] How to SELECT direct and indirect staff Pin
Jassim Rahma15-Nov-16 11:52
Jassim Rahma15-Nov-16 11:52 

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.