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

Database

 
QuestionMigrate columns which have carriage return and line feed Pin
indian1437-Mar-16 12:02
indian1437-Mar-16 12:02 
AnswerRe: Migrate columns which have carriage return and line feed Pin
Richard MacCutchan7-Mar-16 22:04
mveRichard MacCutchan7-Mar-16 22:04 
QuestionRe: Migrate columns which have carriage return and line feed Pin
CHill608-Mar-16 2:26
mveCHill608-Mar-16 2:26 
AnswerRe: Migrate columns which have carriage return and line feed Pin
indian1438-Mar-16 7:36
indian1438-Mar-16 7:36 
QuestionHow to store procedure or function to use in asp.net Pin
hmanhha4-Mar-16 15:52
hmanhha4-Mar-16 15:52 
AnswerRe: How to store procedure or function to use in asp.net Pin
Richard MacCutchan4-Mar-16 22:22
mveRichard MacCutchan4-Mar-16 22:22 
QuestionHow to get exactly date from Oracle Link DB in SQL server. Pin
hmanhha3-Mar-16 16:07
hmanhha3-Mar-16 16:07 
AnswerRe: How to get exactly date from Oracle Link DB in SQL server. Pin
Mycroft Holmes3-Mar-16 19:18
professionalMycroft Holmes3-Mar-16 19:18 
What you are getting is a DATETIME data type which is correct. If you want to display it in a particular format then user CONVERT to get the format you need.

You MUST store the data in your SQL Server table as DATETIME, NEVER store DATETIME as a VARCHAR.
Never underestimate the power of human stupidity
RAH

GeneralRe: How to get exactly date from Oracle Link DB in SQL server. Pin
hmanhha3-Mar-16 22:53
hmanhha3-Mar-16 22:53 
GeneralRe: How to get exactly date from Oracle Link DB in SQL server. Pin
Richard MacCutchan3-Mar-16 23:22
mveRichard MacCutchan3-Mar-16 23:22 
GeneralRe: How to get exactly date from Oracle Link DB in SQL server. Pin
Mycroft Holmes4-Mar-16 12:52
professionalMycroft Holmes4-Mar-16 12:52 
GeneralRe: How to get exactly date from Oracle Link DB in SQL server. Pin
hmanhha6-Mar-16 16:52
hmanhha6-Mar-16 16:52 
GeneralRe: How to get exactly date from Oracle Link DB in SQL server. Pin
Mycroft Holmes6-Mar-16 19:56
professionalMycroft Holmes6-Mar-16 19:56 
GeneralRe: How to get exactly date from Oracle Link DB in SQL server. Pin
hmanhha6-Mar-16 22:09
hmanhha6-Mar-16 22:09 
GeneralRe: How to get exactly date from Oracle Link DB in SQL server. Pin
Jörgen Andersson7-Mar-16 6:35
professionalJörgen Andersson7-Mar-16 6:35 
QuestionConvert Text to datetime Pin
Jassim Rahma2-Mar-16 10:29
Jassim Rahma2-Mar-16 10:29 
AnswerRe: Convert Text to datetime Pin
NickPace2-Mar-16 12:28
NickPace2-Mar-16 12:28 
GeneralRe: Convert Text to datetime Pin
Mycroft Holmes2-Mar-16 19:07
professionalMycroft Holmes2-Mar-16 19:07 
GeneralRe: Convert Text to datetime Pin
NickPace3-Mar-16 4:59
NickPace3-Mar-16 4:59 
Questionbest local database for large tables? (C#, .net) Pin
Frank R. Haugen29-Feb-16 11:00
professionalFrank R. Haugen29-Feb-16 11:00 
QuestionRe: best local database for large tables? (C#, .net) Pin
Jörgen Andersson29-Feb-16 11:46
professionalJörgen Andersson29-Feb-16 11:46 
AnswerRe: best local database for large tables? (C#, .net) Pin
Frank R. Haugen29-Feb-16 12:11
professionalFrank R. Haugen29-Feb-16 12:11 
SuggestionRe: best local database for large tables? (C#, .net) Pin
Richard MacCutchan29-Feb-16 22:07
mveRichard MacCutchan29-Feb-16 22:07 
GeneralRe: best local database for large tables? (C#, .net) Pin
Sascha Lefèvre1-Mar-16 1:34
professionalSascha Lefèvre1-Mar-16 1:34 
GeneralRe: best local database for large tables? (C#, .net) Pin
Richard MacCutchan1-Mar-16 1:43
mveRichard MacCutchan1-Mar-16 1:43 

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.