Click here to Skip to main content
12,070,351 members (50,594 online)
   

Database

 
GeneralRe: SQL query Date Sort Problem Pin
AnirbanM 24-Dec-12 4:27
memberAnirbanM 24-Dec-12 4:27 
GeneralRe: SQL query Date Sort Problem Pin
Eddy Vluggen4-Dec-12 5:44
memberEddy Vluggen4-Dec-12 5:44 
AnswerRe: SQL query Date Sort Problem Pin
Michael Potter4-Dec-12 9:11
memberMichael Potter4-Dec-12 9:11 
AnswerRe: SQL query Date Sort Problem Pin
jschell4-Dec-12 9:23
memberjschell4-Dec-12 9:23 
Questionoltp vs olap Pin
a.fatemeh2-Dec-12 11:51
membera.fatemeh2-Dec-12 11:51 
AnswerRe: oltp vs olap Pin
Mycroft Holmes2-Dec-12 12:49
memberMycroft Holmes2-Dec-12 12:49 
GeneralRe: oltp vs olap Pin
a.fatemeh2-Dec-12 12:57
membera.fatemeh2-Dec-12 12:57 
GeneralRe: oltp vs olap Pin
Mycroft Holmes2-Dec-12 14:28
memberMycroft Holmes2-Dec-12 14:28 
a.fatemeh wrote:
I want an example of this kind of query which is written in both.

Good luck with that, even if you could get the examples it would take a lot explaining to get the context of the requirement. You might want to look into the Microsoft example databases, they have various OLTP and OLAP dbs (AdventureWorks etc), there may be such comparative examples based on them but I doubt it.
Never underestimate the power of human stupidity
RAH

GeneralRe: oltp vs olap Pin
a.fatemeh2-Dec-12 14:41
membera.fatemeh2-Dec-12 14:41 
GeneralSQL instance name when using network group Pin
Aamir Saleem2-Dec-12 11:32
memberAamir Saleem2-Dec-12 11:32 
GeneralRe: SQL instance name when using network group Pin
Mycroft Holmes2-Dec-12 12:43
memberMycroft Holmes2-Dec-12 12:43 
QuestionACL vs SQL for fuzzy matching Pin
Ben Dessau29-Nov-12 5:15
memberBen Dessau29-Nov-12 5:15 
AnswerRe: ACL vs SQL for fuzzy matching Pin
Pete O'Hanlon29-Nov-12 6:07
protectorPete O'Hanlon29-Nov-12 6:07 
GeneralRe: ACL vs SQL for fuzzy matching Pin
Ben Dessau29-Nov-12 7:43
memberBen Dessau29-Nov-12 7:43 
GeneralRe: ACL vs SQL for fuzzy matching Pin
Pete O'Hanlon29-Nov-12 7:50
protectorPete O'Hanlon29-Nov-12 7:50 
QuestionSQL Query Pin
berba29-Nov-12 3:22
memberberba29-Nov-12 3:22 
AnswerRe: SQL Query Pin
Richard Deeming29-Nov-12 3:50
memberRichard Deeming29-Nov-12 3:50 
GeneralRe: SQL Query Pin
berba2-Dec-12 19:30
memberberba2-Dec-12 19:30 
QuestionSQL Server windows authentication Pin
zead29-Nov-12 0:49
memberzead29-Nov-12 0:49 
AnswerRe: SQL Server windows authentication Pin
Garth J Lancaster29-Nov-12 0:59
memberGarth J Lancaster29-Nov-12 0:59 
AnswerRe: SQL Server windows authentication Pin
jschell29-Nov-12 9:09
memberjschell29-Nov-12 9:09 
GeneralRe: SQL Server windows authentication Pin
Chris Meech30-Nov-12 4:45
memberChris Meech30-Nov-12 4:45 
QuestionNeed help with a tricky MS SQL Query Pin
muya mwansa27-Nov-12 7:46
membermuya mwansa27-Nov-12 7:46 
AnswerRe: Need help with a tricky MS SQL Query Pin
Eddy Vluggen27-Nov-12 14:31
memberEddy Vluggen27-Nov-12 14:31 
GeneralRe: Need help with a tricky MS SQL Query Pin
jschell28-Nov-12 9:43
memberjschell28-Nov-12 9:43 

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.


Advertise | Privacy | Mobile
Web03 | 2.8.160208.1 | Last Updated 9 Feb 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid