Click here to Skip to main content
15,850,548 members
Home / Discussions / Database
   

Database

 
GeneralRe: Playing music on my end, with APIs of search engines Pin
Neha.prakash884-May-12 1:19
Neha.prakash884-May-12 1:19 
SuggestionRe: Playing music on my end, with APIs of search engines Pin
Eddy Vluggen4-May-12 1:26
professionalEddy Vluggen4-May-12 1:26 
GeneralRe: Playing music on my end, with APIs of search engines Pin
Neha.prakash884-May-12 1:29
Neha.prakash884-May-12 1:29 
GeneralRe: Playing music on my end, with APIs of search engines Pin
Eddy Vluggen4-May-12 1:39
professionalEddy Vluggen4-May-12 1:39 
Questioncheck date range in between date range Pin
RA|-|UL PATEL2-May-12 21:58
RA|-|UL PATEL2-May-12 21:58 
AnswerRe: check date range in between date range Pin
Blue_Boy2-May-12 22:27
Blue_Boy2-May-12 22:27 
GeneralRe: check date range in between date range Pin
jschell3-May-12 9:42
jschell3-May-12 9:42 
AnswerRe: check date range in between date range Pin
Vishal D Kolekar4-May-12 3:19
professionalVishal D Kolekar4-May-12 3:19 
SELECT *
FROM tablename
where insertdate BETWEEN @startDate and @endDate

this is simple but it won't contain @endDate in result set.
For that you need to use DATEADD(datepart, number, date) fuction
Since your query will be

SELECT *
FROM tablename
WHERE insertdate BETWEEN @startDate and DATEADD(d,1,@endDate)

Thanks,
Vishal K
AnswerRe: check date range in between date range Pin
vvashishta10-May-12 5:50
vvashishta10-May-12 5:50 
Questioncareer Sql developer Pin
Arul R Ece29-Apr-12 21:36
Arul R Ece29-Apr-12 21:36 
AnswerRe: career Sql developer Pin
Richard MacCutchan30-Apr-12 0:13
mveRichard MacCutchan30-Apr-12 0:13 
AnswerRe: career Sql developer Pin
vvashishta30-Apr-12 23:01
vvashishta30-Apr-12 23:01 
AnswerRe: career Sql developer Pin
ZurdoDev1-May-12 3:20
professionalZurdoDev1-May-12 3:20 
AnswerRe: career Sql developer Pin
rana ray3-May-12 2:14
rana ray3-May-12 2:14 
QuestionStore procedure Pin
D.M. Abdur Rahim29-Apr-12 18:25
D.M. Abdur Rahim29-Apr-12 18:25 
AnswerRe: Store procedure Pin
Mycroft Holmes29-Apr-12 18:56
professionalMycroft Holmes29-Apr-12 18:56 
AnswerRe: Store procedure Pin
Richard MacCutchan30-Apr-12 0:12
mveRichard MacCutchan30-Apr-12 0:12 
AnswerRe: Store procedure Pin
Corporal Agarn1-May-12 4:04
professionalCorporal Agarn1-May-12 4:04 
GeneralRe: Store procedure Pin
D.M. Abdur Rahim9-Jul-12 1:01
D.M. Abdur Rahim9-Jul-12 1:01 
QuestionNesting Limit Pin
Andy_L_J28-Apr-12 22:36
Andy_L_J28-Apr-12 22:36 
AnswerRe: Nesting Limit Pin
Mycroft Holmes29-Apr-12 0:21
professionalMycroft Holmes29-Apr-12 0:21 
GeneralRe: Nesting Limit Pin
Andy_L_J29-Apr-12 0:45
Andy_L_J29-Apr-12 0:45 
GeneralRe: Nesting Limit Pin
Mycroft Holmes29-Apr-12 3:39
professionalMycroft Holmes29-Apr-12 3:39 
QuestionRunning Balance Pin
paulaziz26-Apr-12 16:01
paulaziz26-Apr-12 16:01 
AnswerRe: Running Balance Pin
Mycroft Holmes26-Apr-12 20:01
professionalMycroft Holmes26-Apr-12 20:01 

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.