Click here to Skip to main content
15,942,710 members
Home / Discussions / Database
   

Database

 
GeneralRe: How to add image to sql server database ? Pin
Jörgen Andersson2-Nov-10 22:09
professionalJörgen Andersson2-Nov-10 22:09 
AnswerRe: How to add image to sql server database ? Pin
RaviRanjanKr16-Dec-10 3:53
professionalRaviRanjanKr16-Dec-10 3:53 
Questioncan't restore differential backup and tracsaction log. Pin
tan8731-Nov-10 21:31
tan8731-Nov-10 21:31 
AnswerRe: can't restore differential backup and tracsaction log. Pin
Corporal Agarn2-Nov-10 4:47
professionalCorporal Agarn2-Nov-10 4:47 
QuestionEMS SQL for PostgreSQL Pin
Jassim Rahma1-Nov-10 21:10
Jassim Rahma1-Nov-10 21:10 
AnswerRe: EMS SQL for PostgreSQL Pin
TweakBird8-Nov-10 1:07
TweakBird8-Nov-10 1:07 
QuestionPostgreSQL code problem Pin
Jassim Rahma1-Nov-10 3:56
Jassim Rahma1-Nov-10 3:56 
AnswerRe: PostgreSQL code problem Pin
Chris Meech1-Nov-10 7:49
Chris Meech1-Nov-10 7:49 
In your where clause, resume_id = resume_id, that is the same as saying where 1 = 1. It will be true for all rows. I'd recommend changing the name of your parameter to be different from the column name.
CREATE OR REPLACE FUNCTION fn_get_resume_details2(in_resume_id integer)
  RETURNS SETOF record AS
$$select resume_id
        ,resume_title
        ,objective_title
        ,objective_text
        ,summary_title
        ,summary_text
    from resume_details
   where resume_id = in_resume_id;
$$LANGUAGE sql;
Smile | :)
Chris Meech
I am Canadian. [heard in a local bar]

In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]

Questiona column defination list is required for functions returning 'record' [modified] Pin
Jassim Rahma1-Nov-10 3:49
Jassim Rahma1-Nov-10 3:49 
QuestionMessage Removed Pin
31-Oct-10 19:47
MahaKh31-Oct-10 19:47 
AnswerRe: How to connect VC++6 to sql server Repost Pin
Richard MacCutchan31-Oct-10 22:15
mveRichard MacCutchan31-Oct-10 22:15 
QuestionPostgreSQL or MySQL if not SQL Server? Pin
Jassim Rahma31-Oct-10 3:55
Jassim Rahma31-Oct-10 3:55 
AnswerRe: PostgreSQL or MySQL if not SQL Server? Pin
Bernhard Hiller2-Nov-10 0:51
Bernhard Hiller2-Nov-10 0:51 
AnswerRe: PostgreSQL or MySQL if not SQL Server? Pin
TweakBird8-Nov-10 1:09
TweakBird8-Nov-10 1:09 
Questionsyntax error in CONSTRAINT clause Pin
Megidolaon29-Oct-10 9:59
Megidolaon29-Oct-10 9:59 
AnswerRe: syntax error in CONSTRAINT clause Pin
Eddy Vluggen30-Oct-10 23:56
professionalEddy Vluggen30-Oct-10 23:56 
QuestionProblem while Inserting data in Postgres Partitioned table Pin
HalluSin8R29-Oct-10 4:16
HalluSin8R29-Oct-10 4:16 
AnswerRe: Problem while Inserting data in Postgres Partitioned table Pin
Chris Meech29-Oct-10 5:55
Chris Meech29-Oct-10 5:55 
GeneralRe: Problem while Inserting data in Postgres Partitioned table Pin
HalluSin8R31-Oct-10 18:21
HalluSin8R31-Oct-10 18:21 
QuestionBULK INSERT using oracle ODBC driver Pin
hatemtaleb29-Oct-10 2:39
hatemtaleb29-Oct-10 2:39 
AnswerRe: BULK INSERT using oracle ODBC driver Pin
Rajesh Anuhya29-Oct-10 3:06
professionalRajesh Anuhya29-Oct-10 3:06 
GeneralRe: BULK INSERT using oracle ODBC driver Pin
hatemtaleb29-Oct-10 6:22
hatemtaleb29-Oct-10 6:22 
GeneralRe: BULK INSERT using oracle ODBC driver Pin
Mycroft Holmes29-Oct-10 12:40
professionalMycroft Holmes29-Oct-10 12:40 
GeneralRe: BULK INSERT using oracle ODBC driver Pin
Rajesh Anuhya29-Oct-10 18:57
professionalRajesh Anuhya29-Oct-10 18:57 
AnswerRe: BULK INSERT using oracle ODBC driver Pin
Rajesh Anuhya29-Oct-10 18:51
professionalRajesh Anuhya29-Oct-10 18:51 

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.