Click here to Skip to main content
15,397,498 members
Home / Discussions / Database
   

Database

 
GeneralRe: Datediff function Pin
Ambertje26-Jan-15 3:26
MemberAmbertje26-Jan-15 3:26 
GeneralRe: Datediff function Pin
Jörgen Andersson26-Jan-15 21:17
professionalJörgen Andersson26-Jan-15 21:17 
AnswerRe: Datediff function Pin
PIEBALDconsult26-Jan-15 5:57
professionalPIEBALDconsult26-Jan-15 5:57 
GeneralRe: Datediff function Pin
Ambertje26-Jan-15 22:21
MemberAmbertje26-Jan-15 22:21 
GeneralRe: Datediff function Pin
Corporal Agarn27-Jan-15 3:46
professionalCorporal Agarn27-Jan-15 3:46 
GeneralRe: Datediff function Pin
Ambertje3-Feb-15 5:36
MemberAmbertje3-Feb-15 5:36 
GeneralRe: Datediff function Pin
Ambertje27-Jan-15 0:03
MemberAmbertje27-Jan-15 0:03 
QuestionAccess query convert to MSSQL query Pin
Ray Raymos24-Jan-15 9:12
MemberRay Raymos24-Jan-15 9:12 
I have a little bit of SQL code and I am having trouble bringing it over to MSSQL. I don't even know where to being I know that the SELECT, FROM , GROUP BY and HAVING will be in the MSSSQL query.
However I know for a fact the 4th line will change into @param1 and @param2. If anyone would like to add some input into this would be nice.


Access Query
SQL
Select COUNT(') AS Result, Username AS UsernameInput, [Password] 
FROM access
GROUP BY Username, [Password]
Having  (COUNT(') = 1) AND (Username = ?) AND ([Password] = ?)


modified 24-Jan-15 16:04pm.

AnswerRe: Access query convert to MSSQL query Pin
Mycroft Holmes24-Jan-15 12:49
professionalMycroft Holmes24-Jan-15 12:49 
QuestionERD fee management system keep the record of whole year Pin
Haidar ali23-Jan-15 17:04
MemberHaidar ali23-Jan-15 17:04 
AnswerRe: ERD fee management system keep the record of whole year Pin
Richard MacCutchan23-Jan-15 22:45
mveRichard MacCutchan23-Jan-15 22:45 
GeneralRe: ERD fee management system keep the record of whole year Pin
Mycroft Holmes23-Jan-15 23:09
professionalMycroft Holmes23-Jan-15 23:09 
GeneralRe: ERD fee management system keep the record of whole year Pin
Richard MacCutchan23-Jan-15 23:20
mveRichard MacCutchan23-Jan-15 23:20 
GeneralRe: ERD fee management system keep the record of whole year Pin
Haidar ali24-Jan-15 7:41
MemberHaidar ali24-Jan-15 7:41 
GeneralRe: ERD fee management system keep the record of whole year Pin
Haidar ali24-Jan-15 7:42
MemberHaidar ali24-Jan-15 7:42 
GeneralRe: ERD fee management system keep the record of whole year Pin
Richard MacCutchan24-Jan-15 7:47
mveRichard MacCutchan24-Jan-15 7:47 
GeneralRe: ERD fee management system keep the record of whole year Pin
Haidar ali24-Jan-15 7:55
MemberHaidar ali24-Jan-15 7:55 
GeneralRe: ERD fee management system keep the record of whole year Pin
Richard MacCutchan24-Jan-15 8:06
mveRichard MacCutchan24-Jan-15 8:06 
GeneralRe: ERD fee management system keep the record of whole year Pin
Haidar ali25-Jan-15 0:04
MemberHaidar ali25-Jan-15 0:04 
GeneralRe: ERD fee management system keep the record of whole year Pin
Richard MacCutchan25-Jan-15 1:03
mveRichard MacCutchan25-Jan-15 1:03 
QuestionNeed a Select query that filter illegal characters Pin
nainakarri21-Jan-15 19:14
Membernainakarri21-Jan-15 19:14 
AnswerRe: Need a Select query that filter illegal characters Pin
Eddy Vluggen22-Jan-15 0:28
professionalEddy Vluggen22-Jan-15 0:28 
AnswerRe: Need a Select query that filter illegal characters Pin
Umer Akram29-Jan-15 18:58
MemberUmer Akram29-Jan-15 18:58 
QuestionLet sql server code works for all SQLServer versions Pin
MrKBA19-Jan-15 23:10
MemberMrKBA19-Jan-15 23:10 
AnswerRe: Let sql server code works for all SQLServer versions Pin
Eddy Vluggen22-Jan-15 0:26
professionalEddy Vluggen22-Jan-15 0:26 

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.