Click here to Skip to main content
15,921,941 members
Home / Discussions / Database
   

Database

 
GeneralRe: How to get the last record .. Stored Procedure? Pin
Rob Graham1-Nov-08 7:07
Rob Graham1-Nov-08 7:07 
AnswerRe: How to get the last record .. Stored Procedure? Pin
Rob Graham1-Nov-08 7:05
Rob Graham1-Nov-08 7:05 
GeneralRe: How to get the last record .. Stored Procedure? Pin
r_mohd1-Nov-08 11:46
r_mohd1-Nov-08 11:46 
QuestionPervasive 9 Pin
Zeyad Jalil1-Nov-08 4:01
professionalZeyad Jalil1-Nov-08 4:01 
AnswerRe: Pervasive 9 Pin
Ashfield2-Nov-08 21:14
Ashfield2-Nov-08 21:14 
Questionstored procedure for executing another proc generates error Pin
sunny741-Nov-08 0:47
sunny741-Nov-08 0:47 
AnswerRe: stored procedure for executing another proc generates error Pin
Ashfield2-Nov-08 20:10
Ashfield2-Nov-08 20:10 
Questionstored procedure problem in Mysql Pin
avvaru.murali31-Oct-08 1:21
avvaru.murali31-Oct-08 1:21 
Hi,
iam using MySql db,
my stored procedure is like this..

DELIMITER $$

DROP PROCEDURE IF EXISTS `test`.`IS_CITY_EXISTS` $$
CREATE PROCEDURE `IS_CITY_EXISTS`(
IN CITYNAME VARCHAR(45),
OUT AVAILABLE BOOLEAN
)
BEGIN
IF EXISTS(SELECT * FROM city_details WHERE city_name=CITYNAME) THEN
SELECT 1 INTO AVAILABLE;
ELSE
SELECT 0 INTO AVAILABLE;
END IF;
END $$

DELIMITER ;

when iam executing this procedure works fine..
CALL IS_CITY_EXISTS('kak',@Available);
but while exceuting SELECT @AVAILABLE;--IT'S giving result null.
is there any error in procedure..

how can i call this procedure in (c#)..

murali krishna

AnswerRe: stored procedure problem in Mysql Pin
Wendelius2-Nov-08 0:05
mentorWendelius2-Nov-08 0:05 
QuestionFunction syntax in Mysql Pin
kyi kyi30-Oct-08 17:51
kyi kyi30-Oct-08 17:51 
AnswerRe: Function syntax in Mysql Pin
Ashfield30-Oct-08 22:23
Ashfield30-Oct-08 22:23 
AnswerRe: Function syntax in Mysql Pin
Paul Conrad31-Oct-08 7:42
professionalPaul Conrad31-Oct-08 7:42 
QuestionRestore DataBase Pin
Thaer Hamael30-Oct-08 2:23
Thaer Hamael30-Oct-08 2:23 
AnswerRe: Restore DataBase Pin
Wendelius30-Oct-08 7:49
mentorWendelius30-Oct-08 7:49 
QuestionSql server 2005 Pin
jetwll30-Oct-08 1:08
jetwll30-Oct-08 1:08 
AnswerRe: Sql server 2005 Pin
Ashfield30-Oct-08 2:15
Ashfield30-Oct-08 2:15 
Questionsql query Pin
joindotnet29-Oct-08 20:02
joindotnet29-Oct-08 20:02 
AnswerRe: sql query Pin
Meysam Mahfouzi29-Oct-08 20:05
Meysam Mahfouzi29-Oct-08 20:05 
QuestionRe: sql query Pin
joindotnet29-Oct-08 20:12
joindotnet29-Oct-08 20:12 
AnswerRe: sql query Pin
Giorgi Dalakishvili29-Oct-08 20:29
mentorGiorgi Dalakishvili29-Oct-08 20:29 
AnswerRe: sql query Pin
vaseeem30-Oct-08 9:31
vaseeem30-Oct-08 9:31 
AnswerRe: sql query Pin
Eddy Vluggen30-Oct-08 23:42
professionalEddy Vluggen30-Oct-08 23:42 
GeneralRe: sql query Pin
joindotnet30-Oct-08 23:58
joindotnet30-Oct-08 23:58 
AnswerRe: sql query Pin
Eddy Vluggen31-Oct-08 0:49
professionalEddy Vluggen31-Oct-08 0:49 
GeneralRe: sql query Pin
joindotnet31-Oct-08 1:09
joindotnet31-Oct-08 1:09 

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.