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

Database

 
GeneralRe: SQL Server file locations. Pin
Septimus Hedgehog16-Jul-13 3:18
Septimus Hedgehog16-Jul-13 3:18 
GeneralRe: SQL Server file locations. Pin
Corporal Agarn16-Jul-13 4:18
professionalCorporal Agarn16-Jul-13 4:18 
GeneralRe: SQL Server file locations. Pin
Septimus Hedgehog16-Jul-13 4:44
Septimus Hedgehog16-Jul-13 4:44 
QuestionHow to replace string with stuff ? Pin
caulsonchua15-Jul-13 23:03
caulsonchua15-Jul-13 23:03 
AnswerRe: How to replace string with stuff ? Pin
Richard Deeming16-Jul-13 1:37
mveRichard Deeming16-Jul-13 1:37 
GeneralRe: How to replace string with stuff ? Pin
caulsonchua16-Jul-13 1:39
caulsonchua16-Jul-13 1:39 
GeneralRe: How to replace string with stuff ? Pin
Richard Deeming16-Jul-13 1:50
mveRichard Deeming16-Jul-13 1:50 
AnswerRe: How to replace string with stuff ? Pin
Mycroft Holmes16-Jul-13 12:44
professionalMycroft Holmes16-Jul-13 12:44 
Let me reinforce what Richard has said, NEVER store date as text/varchar/char, ALWAYS use the correct data type.

Text will give you endless problems whenever you try and manipulate the data. The date and datetime data types will give you the tools to manipulate the data easily (not simply it can take a bit of thinking to work out how to achieve a given result).
Never underestimate the power of human stupidity
RAH

QuestionMounting .DBF files (Oracle Database 11g) Pin
prathameshpitale15-Jul-13 5:33
prathameshpitale15-Jul-13 5:33 
AnswerRe: Mounting .DBF files (Oracle Database 11g) Pin
Maciej Los29-Jul-13 23:46
mveMaciej Los29-Jul-13 23:46 
GeneralRe: Mounting .DBF files (Oracle Database 11g) Pin
prathameshpitale30-Jul-13 5:40
prathameshpitale30-Jul-13 5:40 
QuestionORA-12560 TNS : protocol adapter error; ORA-1033 Oracle initialization or shutdown in progress Pin
prathameshpitale15-Jul-13 5:33
prathameshpitale15-Jul-13 5:33 
QuestionHow to find ladder in sql query Pin
Member 356741115-Jul-13 2:02
Member 356741115-Jul-13 2:02 
AnswerRe: How to find ladder in sql query Pin
Niral Soni15-Jul-13 5:00
Niral Soni15-Jul-13 5:00 
AnswerRe: How to find ladder in sql query Pin
karna from Hyderabad22-Jul-13 21:01
karna from Hyderabad22-Jul-13 21:01 
Questiondatabase course Pin
V.14-Jul-13 22:32
professionalV.14-Jul-13 22:32 
AnswerRe: database course Pin
Eddy Vluggen15-Jul-13 0:30
professionalEddy Vluggen15-Jul-13 0:30 
GeneralRe: database course Pin
V.15-Jul-13 1:30
professionalV.15-Jul-13 1:30 
QuestionFIlestream of varbinary ? ( To Store files) Pin
Amol_B14-Jul-13 21:22
professionalAmol_B14-Jul-13 21:22 
AnswerRe: FIlestream of varbinary ? ( To Store files) Pin
Richard MacCutchan14-Jul-13 22:29
mveRichard MacCutchan14-Jul-13 22:29 
AnswerRe: FIlestream of varbinary ? ( To Store files) Pin
Mycroft Holmes14-Jul-13 22:42
professionalMycroft Holmes14-Jul-13 22:42 
GeneralRe: FIlestream of varbinary ? ( To Store files) Pin
Amol_B14-Jul-13 22:58
professionalAmol_B14-Jul-13 22:58 
Questionneed an sql query to extract results in the attached format Pin
vijays.30198914-Jul-13 3:40
vijays.30198914-Jul-13 3:40 
Questionbackup in sqllocaldb Pin
dharmaa.m12-Jul-13 7:57
dharmaa.m12-Jul-13 7:57 
AnswerRe: backup in sqllocaldb Pin
NotPolitcallyCorrect12-Jul-13 8:36
NotPolitcallyCorrect12-Jul-13 8:36 

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.