Click here to Skip to main content
15,902,636 members
Home / Discussions / Database
   

Database

 
QuestionInserting rows dynamiccaly on based on calculation Pin
vkap20-Jun-12 11:45
vkap20-Jun-12 11:45 
AnswerRe: Inserting rows dynamiccaly on based on calculation Pin
Mycroft Holmes20-Jun-12 13:05
professionalMycroft Holmes20-Jun-12 13:05 
AnswerRe: Inserting rows dynamiccaly on based on calculation Pin
__TR__3-Jul-12 20:41
__TR__3-Jul-12 20:41 
Questionlan chat software Pin
Member 913183919-Jun-12 1:42
Member 913183919-Jun-12 1:42 
AnswerRe: lan chat software Pin
Richard MacCutchan19-Jun-12 2:01
mveRichard MacCutchan19-Jun-12 2:01 
AnswerRe: lan chat software Pin
Eddy Vluggen19-Jun-12 2:36
professionalEddy Vluggen19-Jun-12 2:36 
AnswerRe: lan chat software Pin
Paul Conrad19-Jun-12 8:19
professionalPaul Conrad19-Jun-12 8:19 
QuestionError 1064,.... please Help Pin
Jassim Rahma16-Jun-12 0:10
Jassim Rahma16-Jun-12 0:10 
Hi,

I am getting the above error on MySQL stored procedure..

Kindly help...

here is the error followed by the code:

SQL
1064 - You have and error in your SQL syntax. check the manual that corresponds to your MySQL server version for the right syntax to use near '
END
ELSE
BEGIN
INSERT INTO salary_slips (salary_slip_month, salary_slip_y'
at line 13


SQL
BEGIN
    SET param_slip_released = FALSE;

    IF EXISTS (SELECT salary_slip_id FROM salary_slips WHERE salary_slip_month = param_slip_month AND salary_slip_year = param_slip_year) THEN
    BEGIN
        SET param_slip_released = (SELECT salary_slip_released FROM salary_slips WHERE salary_slip_month = param_slip_month AND salary_slip_year = param_slip_year);

        IF param_slip_released = FALSE THEN
        BEGIN
            SELECT * FROM salary_slips;
        END
    END
    ELSE
    BEGIN
        INSERT INTO salary_slips (salary_slip_month, salary_slip_year) VALUES (param_slip_month, param_slip_year);
    END
END;

AnswerRe: Error 1064,.... please Help Pin
Mycroft Holmes16-Jun-12 3:14
professionalMycroft Holmes16-Jun-12 3:14 
Questionif - else statement in sql Pin
begg15-Jun-12 8:36
begg15-Jun-12 8:36 
AnswerRe: if - else statement in sql Pin
Corporal Agarn15-Jun-12 8:41
professionalCorporal Agarn15-Jun-12 8:41 
AnswerRe: if - else statement in sql Pin
Michael Potter15-Jun-12 10:18
Michael Potter15-Jun-12 10:18 
AnswerRe: if - else statement in sql Pin
vvashishta18-Jun-12 19:49
vvashishta18-Jun-12 19:49 
AnswerRe: if - else statement in sql Pin
rimazuc20-Jun-12 5:31
rimazuc20-Jun-12 5:31 
AnswerRe: if - else statement in sql Pin
rimazuc20-Jun-12 5:40
rimazuc20-Jun-12 5:40 
AnswerRe: if - else statement in sql Pin
hearthofmine24-Jun-12 22:33
hearthofmine24-Jun-12 22:33 
QuestionHow can i select all dates between date range? Pin
RA|-|UL PATEL15-Jun-12 3:30
RA|-|UL PATEL15-Jun-12 3:30 
AnswerRe: How can i select all dates between date range? Pin
bobrien10015-Jun-12 8:11
bobrien10015-Jun-12 8:11 
GeneralRe: How can i select all dates between date range? Pin
Corporal Agarn15-Jun-12 8:44
professionalCorporal Agarn15-Jun-12 8:44 
AnswerRe: How can i select all dates between date range? Pin
Mycroft Holmes15-Jun-12 13:44
professionalMycroft Holmes15-Jun-12 13:44 
AnswerRe: How can i select all dates between date range? Pin
Jörgen Andersson15-Jun-12 22:36
professionalJörgen Andersson15-Jun-12 22:36 
AnswerRe: How can i select all dates between date range? Pin
vvashishta18-Jun-12 20:09
vvashishta18-Jun-12 20:09 
Questionhow to make a duplicate database with new name in SQL Server 2008 Pin
nvarunkumar15-Jun-12 0:06
nvarunkumar15-Jun-12 0:06 
AnswerRe: how to make a duplicate database with new name in SQL Server 2008 Pin
Sandeep Mewara15-Jun-12 1:11
mveSandeep Mewara15-Jun-12 1:11 
GeneralRe: how to make a duplicate database with new name in SQL Server 2008 Pin
nvarunkumar15-Jun-12 2:04
nvarunkumar15-Jun-12 2:04 

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.