Click here to Skip to main content
15,920,603 members
Home / Discussions / Database
   

Database

 
QuestionSQL 2000 vs 2005 vs 2008 Pin
jgrogan22-May-08 6:04
jgrogan22-May-08 6:04 
QuestionSingle Column Tables Pin
Tristan Rhodes22-May-08 3:36
Tristan Rhodes22-May-08 3:36 
AnswerRe: Single Column Tables Pin
Alsvha22-May-08 18:23
Alsvha22-May-08 18:23 
QuestionExporting/Importing Database in sql sevrer 2000 using c# Pin
Berlus22-May-08 2:22
Berlus22-May-08 2:22 
AnswerRe: Exporting/Importing Database in sql sevrer 2000 using c# Pin
Mycroft Holmes23-May-08 0:33
professionalMycroft Holmes23-May-08 0:33 
QuestionBeginner's for STORED PROCEDURES and triggers Pin
Karan_TN22-May-08 0:44
Karan_TN22-May-08 0:44 
AnswerRe: Beginner's for STORED PROCEDURES and triggers Pin
John_Adams22-May-08 1:06
John_Adams22-May-08 1:06 
GeneralRe: Beginner's for STORED PROCEDURES and triggers Pin
Karan_TN22-May-08 21:24
Karan_TN22-May-08 21:24 
Question14 days back date Pin
trilokharry21-May-08 23:49
trilokharry21-May-08 23:49 
AnswerRe: 14 days back date Pin
Colin Angus Mackay22-May-08 0:29
Colin Angus Mackay22-May-08 0:29 
AnswerRe: 14 days back date Pin
GuyThiebaut22-May-08 1:32
professionalGuyThiebaut22-May-08 1:32 
GeneralRe: 14 days back date Pin
Mycroft Holmes23-May-08 0:38
professionalMycroft Holmes23-May-08 0:38 
GeneralRe: 14 days back date Pin
GuyThiebaut23-May-08 8:22
professionalGuyThiebaut23-May-08 8:22 
QuestionvbSQLParser -- Which assembly it belongs to? Pin
Vasudevan Deepak Kumar21-May-08 21:09
Vasudevan Deepak Kumar21-May-08 21:09 
AnswerRe: vbSQLParser -- Which assembly it belongs to? Pin
Vasudevan Deepak Kumar21-May-08 21:51
Vasudevan Deepak Kumar21-May-08 21:51 
QuestionDataType... Pin
Jamal Abdul Nasir21-May-08 20:38
Jamal Abdul Nasir21-May-08 20:38 
AnswerRe: DataType... Pin
GuyThiebaut21-May-08 20:49
professionalGuyThiebaut21-May-08 20:49 
GeneralRe: DataType... Pin
Mycroft Holmes23-May-08 0:42
professionalMycroft Holmes23-May-08 0:42 
AnswerRe: DataType... Pin
Blue_Boy21-May-08 21:13
Blue_Boy21-May-08 21:13 
QuestionHelp for a beginner Pin
Boshkash21-May-08 7:17
Boshkash21-May-08 7:17 
AnswerRe: Help for a beginner Pin
Mark J. Miller21-May-08 7:45
Mark J. Miller21-May-08 7:45 
To get the difference between 2 dates use the DATEDIFF function.

But there's no need to store the TripTime since you've already stored Leaving and Arrival. If you store it you are going to risk the data getting out of sync if there are any changes. Instead, whenever you need to get the tip time, just make a call to DATEDIFF using leaving and arrival times.


GeneralRe: Help for a beginner Pin
Mike Dimmick22-May-08 3:12
Mike Dimmick22-May-08 3:12 
QuestionDelete and Truncate Pin
.NET- India 21-May-08 6:45
.NET- India 21-May-08 6:45 
AnswerRe: Delete and Truncate Pin
SomeGuyThatIsMe21-May-08 7:03
SomeGuyThatIsMe21-May-08 7:03 
AnswerRe: Delete and Truncate Pin
Michael Potter21-May-08 10:38
Michael Potter21-May-08 10:38 

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.