Click here to Skip to main content
15,867,832 members
Home / Discussions / Database
   

Database

 
AnswerRe: how to update statement from subselect? Pin
MatthysDT5-Oct-07 1:59
MatthysDT5-Oct-07 1:59 
GeneralRe: how to update statement from subselect? Pin
Eunice (VB junior)8-Oct-07 16:22
Eunice (VB junior)8-Oct-07 16:22 
AnswerRe: how to update statement from subselect? Pin
GuyThiebaut5-Oct-07 9:59
professionalGuyThiebaut5-Oct-07 9:59 
GeneralRe: how to update statement from subselect? [modified] Pin
Eunice (VB junior)8-Oct-07 15:45
Eunice (VB junior)8-Oct-07 15:45 
GeneralRe: how to update statement from subselect? Pin
GuyThiebaut8-Oct-07 22:42
professionalGuyThiebaut8-Oct-07 22:42 
Questionalteration of date format in table column Pin
Sonia Gupta4-Oct-07 21:57
Sonia Gupta4-Oct-07 21:57 
AnswerRe: alteration of date format in table column Pin
Colin Angus Mackay4-Oct-07 22:08
Colin Angus Mackay4-Oct-07 22:08 
AnswerRe: alteration of date format in table column Pin
Imran Khan Pathan4-Oct-07 23:08
Imran Khan Pathan4-Oct-07 23:08 
You can not store datetime in any format but if you want to store datetime in "12-Jan-2007" format you have to take varchar datatype instead of datetie datatype.

Other way is you can get datetime in "12-Jan-2007" this format in asp.net by String.Format Method.


bEST rEGARD
pATHAN

please don't forget to vote on the post that helped you.

GeneralRe: alteration of date format in table column Pin
Sonia Gupta4-Oct-07 23:22
Sonia Gupta4-Oct-07 23:22 
GeneralRe: alteration of date format in table column Pin
pmarfleet4-Oct-07 23:28
pmarfleet4-Oct-07 23:28 
QuestionSQLServer Activity Logs Pin
Vasudevan Deepak Kumar4-Oct-07 20:56
Vasudevan Deepak Kumar4-Oct-07 20:56 
QuestionProblem in Join Pin
banker_kiran4-Oct-07 20:39
banker_kiran4-Oct-07 20:39 
AnswerRe: Problem in Join Pin
pmarfleet4-Oct-07 22:05
pmarfleet4-Oct-07 22:05 
Questionproblem in a query Pin
Shuaib wasif khan4-Oct-07 13:55
Shuaib wasif khan4-Oct-07 13:55 
AnswerRe: problem in a query Pin
pmarfleet4-Oct-07 19:47
pmarfleet4-Oct-07 19:47 
QuestionTableAdapter Insert Query - a mystery Pin
dmagnant4-Oct-07 9:42
dmagnant4-Oct-07 9:42 
AnswerRe: TableAdapter Insert Query - a mystery Pin
dmagnant4-Oct-07 9:57
dmagnant4-Oct-07 9:57 
QuestionProblem with local website after using SSMSE to access the database Pin
Sunset Towers4-Oct-07 8:13
Sunset Towers4-Oct-07 8:13 
QuestionHow to fetch the no of records retrieved thru FULLTEXT Pin
s.sathyanarayanan4-Oct-07 8:12
s.sathyanarayanan4-Oct-07 8:12 
AnswerRe: How to fetch the no of records retrieved thru FULLTEXT Pin
Joe4-Oct-07 9:05
Joe4-Oct-07 9:05 
GeneralRe: How to fetch the no of records retrieved thru FULLTEXT Pin
s.sathyanarayanan4-Oct-07 9:11
s.sathyanarayanan4-Oct-07 9:11 
GeneralRe: How to fetch the no of records retrieved thru FULLTEXT Pin
Joe4-Oct-07 19:30
Joe4-Oct-07 19:30 
GeneralRe: How to fetch the no of records retrieved thru FULLTEXT Pin
Vasudevan Deepak Kumar4-Oct-07 19:43
Vasudevan Deepak Kumar4-Oct-07 19:43 
QuestionHow do we select only those columns that aren`t null Pin
NetBot4-Oct-07 8:06
NetBot4-Oct-07 8:06 
AnswerRe: How do we select only those columns that aren`t null Pin
Joe4-Oct-07 8:57
Joe4-Oct-07 8:57 

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.