Click here to Skip to main content
15,797,608 members
Home / Discussions / Database
   

Database

 
GeneralRe: How do I run my SQL script from .msi ?? Pin
IrishSonic24-Aug-04 1:39
IrishSonic24-Aug-04 1:39 
QuestionUpdate database from a XML dataset file ? Pin
zWyThoS23-Aug-04 12:22
zWyThoS23-Aug-04 12:22 
AnswerRe: Update database from a XML dataset file ? Pin
S Sansanwal23-Aug-04 13:17
S Sansanwal23-Aug-04 13:17 
AnswerRe: Update database from a XML dataset file ? Pin
mikasa25-Aug-04 12:27
mikasa25-Aug-04 12:27 
QuestionDISTINCT values of Datatable columns??? Pin
mittalpa23-Aug-04 11:43
mittalpa23-Aug-04 11:43 
AnswerRe: DISTINCT values of Datatable columns??? Pin
S Sansanwal23-Aug-04 13:24
S Sansanwal23-Aug-04 13:24 
GeneralRe: DISTINCT values of Datatable columns??? Pin
mittalpa24-Aug-04 4:23
mittalpa24-Aug-04 4:23 
GeneralSmallDateTime and changing to DateTime Pin
Paul Watson23-Aug-04 8:37
sitebuilderPaul Watson23-Aug-04 8:37 
So you would think a SQL expert like me *ok you didn't have to laugh so loud* would already know this, but I didn't and got burnt.

SmallDateTime rounds seconds to the nearest minute. Fair enough. I didn't know but hey, we have DateTime so lets change the column datatype to that.

Only existing records are not affected. WTF! They act like the column is still a SmallDateTime. Manually adding in a second to the value doesn't help existing records either alas.

So I convert to NVarchar as a temporary hack and use GetDate. Charming, still no seconds. WTF!

So my question is; apart from recreating the whole column and loosing that data, how do I get what was a former SmallDateTime and is now a DateTime to store seconds on existing rows?


I am sure this is one of those Design Features too.

regards,
Paul Watson
Bluegrass
South Africa

Christopher Duncan wrote:
"I always knew that somewhere deep inside that likable, Save the Whales kinda guy there lurked the heart of a troublemaker..."

Crikey! ain't life grand?

GeneralRe: SmallDateTime and changing to DateTime Pin
Colin Angus Mackay23-Aug-04 10:57
Colin Angus Mackay23-Aug-04 10:57 
GeneralRe: SmallDateTime and changing to DateTime Pin
Steven Campbell23-Aug-04 11:16
Steven Campbell23-Aug-04 11:16 
QuestionHow to retrieve data from stored function? Pin
Chodici Mrkev23-Aug-04 6:57
Chodici Mrkev23-Aug-04 6:57 
AnswerRe: How to retrieve data from stored function? Pin
Colin Angus Mackay23-Aug-04 7:15
Colin Angus Mackay23-Aug-04 7:15 
GeneralRe: How to retrieve data from stored function? Pin
Chodici Mrkev23-Aug-04 9:55
Chodici Mrkev23-Aug-04 9:55 
GeneralRe: How to retrieve data from stored function? Pin
Colin Angus Mackay23-Aug-04 10:54
Colin Angus Mackay23-Aug-04 10:54 
GeneralRe: How to retrieve data from stored function? Pin
Colin Angus Mackay23-Aug-04 12:09
Colin Angus Mackay23-Aug-04 12:09 
GeneralRe: How to retrieve data from stored function? Pin
Chodici Mrkev23-Aug-04 12:28
Chodici Mrkev23-Aug-04 12:28 
GeneralThanks Pin
Colin Angus Mackay23-Aug-04 12:45
Colin Angus Mackay23-Aug-04 12:45 
GeneralHandling of Fetched Records Pin
pry50422-Aug-04 22:47
pry50422-Aug-04 22:47 
GeneralRe: Handling of Fetched Records Pin
David Salter23-Aug-04 4:03
David Salter23-Aug-04 4:03 
GeneralRe: Handling of Fetched Records Pin
pry50423-Aug-04 5:38
pry50423-Aug-04 5:38 
GeneralCompiler Error Pin
#realJSOP22-Aug-04 13:33
mve#realJSOP22-Aug-04 13:33 
GeneralRe: Compiler Error Pin
S Sansanwal22-Aug-04 14:41
S Sansanwal22-Aug-04 14:41 
GeneralRe: Compiler Error Pin
#realJSOP23-Aug-04 0:33
mve#realJSOP23-Aug-04 0:33 
GeneralDatagrid data refresh problem Pin
lkreuzer22-Aug-04 8:17
lkreuzer22-Aug-04 8:17 
GeneralDataColumn question Pin
blankg22-Aug-04 7:47
blankg22-Aug-04 7:47 

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.