Click here to Skip to main content
15,565,661 members
Home / Discussions / Database
   

Database

 
AnswerRe: SQL convert(datetime, number) wrong? Pin
Jörgen Andersson29-Jun-14 23:39
professionalJörgen Andersson29-Jun-14 23:39 
GeneralRe: SQL convert(datetime, number) wrong? Pin
Miller Nguyen29-Jun-14 23:52
Miller Nguyen29-Jun-14 23:52 
GeneralRe: SQL convert(datetime, number) wrong? Pin
Jörgen Andersson30-Jun-14 0:03
professionalJörgen Andersson30-Jun-14 0:03 
GeneralRe: SQL convert(datetime, number) wrong? Pin
Bernhard Hiller30-Jun-14 1:38
Bernhard Hiller30-Jun-14 1:38 
GeneralRe: SQL convert(datetime, number) wrong? Pin
Jörgen Andersson30-Jun-14 2:15
professionalJörgen Andersson30-Jun-14 2:15 
AnswerRe: SQL convert(datetime, number) wrong? Pin
GuyThiebaut30-Jun-14 1:52
professionalGuyThiebaut30-Jun-14 1:52 
QuestionMySQL Stored Procs - Pin
ericgahn29-Jun-14 10:08
ericgahn29-Jun-14 10:08 
AnswerRe: MySQL Stored Procs - Pin
Wayne Gaylard29-Jun-14 23:37
professionalWayne Gaylard29-Jun-14 23:37 
You don't need the delimiter expression $$ after your END statement.
SQL
DELIMITER $$

DROP PROCEDURE IF EXISTS CleanCopyEnvData$$

CREATE PROCEDURE CleanCopyEnvData ()
BEGIN

  insert into  EnvData(UserDate, XAction, Balance, UserID)
  select
    CAST(udate as Date)
    , CAST(amount1 as Decimal(6,3))
    , CAST(amount2 as Decimal(6,3))
    , CAST(UID as UnSigned)
  from
    DataLoad;

END

Everyone dies - but not everyone lives

GeneralRe: MySQL Stored Procs - Pin
ericgahn1-Jul-14 20:03
ericgahn1-Jul-14 20:03 
GeneralRe: MySQL Stored Procs - Pin
Wayne Gaylard1-Jul-14 20:28
professionalWayne Gaylard1-Jul-14 20:28 
QuestionQuestion about File Server / MySQL Database Pin
Jassim Rahma29-Jun-14 3:30
Jassim Rahma29-Jun-14 3:30 
AnswerRe: Question about File Server / MySQL Database Pin
Peter Leow29-Jun-14 4:19
professionalPeter Leow29-Jun-14 4:19 
AnswerRe: Question about File Server / MySQL Database Pin
Bernhard Hiller29-Jun-14 22:12
Bernhard Hiller29-Jun-14 22:12 
Questiondatabase Pin
sheikh muneeb28-Jun-14 8:18
sheikh muneeb28-Jun-14 8:18 
AnswerRe: database Pin
PIEBALDconsult28-Jun-14 8:33
professionalPIEBALDconsult28-Jun-14 8:33 
GeneralRe: database Pin
sheikh muneeb28-Jun-14 8:49
sheikh muneeb28-Jun-14 8:49 
GeneralRe: database Pin
PIEBALDconsult28-Jun-14 8:52
professionalPIEBALDconsult28-Jun-14 8:52 
GeneralRe: database Pin
sheikh muneeb28-Jun-14 8:56
sheikh muneeb28-Jun-14 8:56 
GeneralRe: database Pin
PIEBALDconsult28-Jun-14 8:58
professionalPIEBALDconsult28-Jun-14 8:58 
GeneralRe: database Pin
Shameel2-Jul-14 2:08
professionalShameel2-Jul-14 2:08 
AnswerRe: database Pin
Bernhard Hiller29-Jun-14 22:25
Bernhard Hiller29-Jun-14 22:25 
QuestionWhat is the difference between Data Warehouse and Database? Pin
Bastien Vandamme26-Jun-14 21:28
Bastien Vandamme26-Jun-14 21:28 
AnswerRe: What is the difference between Data Warehouse and Database? Pin
thatraja26-Jun-14 22:04
professionalthatraja26-Jun-14 22:04 
GeneralRe: What is the difference between Data Warehouse and Database? Pin
Bastien Vandamme26-Jun-14 22:28
Bastien Vandamme26-Jun-14 22:28 
AnswerRe: What is the difference between Data Warehouse and Database? Pin
thatraja26-Jun-14 22:35
professionalthatraja26-Jun-14 22:35 

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.