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

Database

 
GeneralRe: Is it recommended to use trigger to manage business rules with SQL Server? Pin
Kornfeld Eliyahu Peter22-Jun-14 23:28
professionalKornfeld Eliyahu Peter22-Jun-14 23:28 
AnswerRe: Is it recommended to use trigger to manage business rules with SQL Server? Pin
Jörgen Andersson22-Jun-14 20:52
professionalJörgen Andersson22-Jun-14 20:52 
AnswerRe: Is it recommended to use trigger to manage business rules with SQL Server? Pin
Mycroft Holmes23-Jun-14 2:04
professionalMycroft Holmes23-Jun-14 2:04 
QuestionCompare two tabel and add/update query Pin
member002618-Jun-14 21:44
member002618-Jun-14 21:44 
AnswerRe: Compare two tabel and add/update query Pin
Mycroft Holmes18-Jun-14 23:33
professionalMycroft Holmes18-Jun-14 23:33 
QuestionValidate Date Time value on Sqlite before insert / update Pin
rahmat198517-Jun-14 23:29
rahmat198517-Jun-14 23:29 
AnswerRe: Validate Date Time value on Sqlite before insert / update Pin
Mycroft Holmes17-Jun-14 23:57
professionalMycroft Holmes17-Jun-14 23:57 
GeneralRe: Validate Date Time value on Sqlite before insert / update Pin
Eddy Vluggen18-Jun-14 1:28
professionalEddy Vluggen18-Jun-14 1:28 
Mycroft Holmes wrote:
You should be storing the data as a datetime TYPE not a string
SQLite does not have a DATETIME datatype. I'd recommend storing it as an integer, as recommend on their website[^].
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]

GeneralRe: Validate Date Time value on Sqlite before insert / update Pin
Mycroft Holmes18-Jun-14 13:44
professionalMycroft Holmes18-Jun-14 13:44 
GeneralRe: Validate Date Time value on Sqlite before insert / update Pin
Bernhard Hiller19-Jun-14 23:26
Bernhard Hiller19-Jun-14 23:26 
GeneralRe: Validate Date Time value on Sqlite before insert / update Pin
Eddy Vluggen20-Jun-14 1:30
professionalEddy Vluggen20-Jun-14 1:30 
GeneralRe: Validate Date Time value on Sqlite before insert / update Pin
PIEBALDconsult20-Jun-14 10:45
professionalPIEBALDconsult20-Jun-14 10:45 
GeneralRe: Validate Date Time value on Sqlite before insert / update Pin
Eddy Vluggen20-Jun-14 11:01
professionalEddy Vluggen20-Jun-14 11:01 
GeneralRe: Validate Date Time value on Sqlite before insert / update Pin
PIEBALDconsult20-Jun-14 11:30
professionalPIEBALDconsult20-Jun-14 11:30 
GeneralRe: Validate Date Time value on Sqlite before insert / update Pin
Eddy Vluggen20-Jun-14 11:45
professionalEddy Vluggen20-Jun-14 11:45 
GeneralRe: Validate Date Time value on Sqlite before insert / update Pin
PIEBALDconsult20-Jun-14 10:43
professionalPIEBALDconsult20-Jun-14 10:43 
AnswerRe: Validate Date Time value on Sqlite before insert / update Pin
Eddy Vluggen18-Jun-14 1:29
professionalEddy Vluggen18-Jun-14 1:29 
AnswerRe: Validate Date Time value on Sqlite before insert / update Pin
jschell18-Jun-14 12:23
jschell18-Jun-14 12:23 
AnswerRe: Validate Date Time value on Sqlite before insert / update Pin
PIEBALDconsult20-Jun-14 10:46
professionalPIEBALDconsult20-Jun-14 10:46 
QuestionSQL search question Pin
Jassim Rahma16-Jun-14 23:14
Jassim Rahma16-Jun-14 23:14 
AnswerRe: SQL search question Pin
Eddy Vluggen16-Jun-14 23:29
professionalEddy Vluggen16-Jun-14 23:29 
AnswerRe: SQL search question Pin
NitinDhapte17-Jun-14 0:08
NitinDhapte17-Jun-14 0:08 
AnswerRe: SQL search question Pin
Shameel17-Jun-14 1:48
professionalShameel17-Jun-14 1:48 
GeneralRe: SQL search question Pin
Jassim Rahma17-Jun-14 2:35
Jassim Rahma17-Jun-14 2:35 
AnswerRe: SQL search question Pin
Shameel17-Jun-14 6:31
professionalShameel17-Jun-14 6:31 

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.