Click here to Skip to main content
   

Database

 
AnswerRe: Change the language for Sql Server 2008 PinmemberMycroft Holmes19-Jan-13 15:19 
Questionsql server 2008 PinmemberKapilkp18-Jan-13 0:25 
QuestionRe: sql server 2008 PinmvpEddy Vluggen18-Jan-13 2:30 
GeneralRe: sql server 2008 PinmemberKapilkp21-Jan-13 0:06 
GeneralRe: sql server 2008 PinmvpEddy Vluggen21-Jan-13 2:15 
GeneralRe: sql server 2008 PinmemberPIEBALDconsult21-Jan-13 5:57 
AnswerRe: sql server 2008 PinmemberPIEBALDconsult18-Jan-13 5:01 
Questionsql server Pinmemberyogika17-Jan-13 20:15 
Is these differences are correct or not as interviewer said me these are incorrect....please guide me...

Difference between function and SP
Procedure can return zero or n values whereas function can return one value which is mandatory.
Procedures can have input/output parameters for it whereas functions can have only input parameters.
Procedure allows select as well as DML statement in it whereas function allows only select statement in it.
Functions can be called from procedure whereas procedures cannot be called from function.
Exception can be handled by try-catch block in a procedure whereas try-catch block cannot be used in a function.

AnswerRe: sql server PinmvpEddy Vluggen18-Jan-13 2:37 
AnswerRe: sql server PinmemberRichard Deeming18-Jan-13 2:37 
GeneralRe: sql server PinmvpEddy Vluggen18-Jan-13 3:13 
GeneralRe: sql server PinmemberRichard Deeming18-Jan-13 3:18 
GeneralRe: sql server PinmvpEddy Vluggen18-Jan-13 3:22 
GeneralRe: sql server PinmemberPIEBALDconsult18-Jan-13 15:36 
AnswerRe: sql server PinmemberPIEBALDconsult18-Jan-13 5:04 
GeneralRe: sql server PinmemberShameel22-Jan-13 5:31 
QuestionDo I need a pivot Query? PinmemberGREG_DORIANcod16-Jan-13 11:09 
AnswerRe: Do I need a pivot Query? PinmemberMycroft Holmes16-Jan-13 20:36 
GeneralRe: Do I need a pivot Query? PinmemberGREG_DORIANcod17-Jan-13 2:59 
AnswerRe: Do I need a pivot Query? PinmemberJörgen Andersson21-Jan-13 9:58 
QuestionTotals of each transaction type PinmemberRichard.Berry10015-Jan-13 22:38 
AnswerRe: Totals of each transaction type PinmemberMycroft Holmes15-Jan-13 23:57 
GeneralRe: Totals of each transaction type PinmemberRichard.Berry10016-Jan-13 1:36 
GeneralRe: Totals of each transaction type PinmemberPIEBALDconsult16-Jan-13 4:42 
GeneralRe: Totals of each transaction type PinmemberRichard.Berry10016-Jan-13 6:36 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web01 | 2.8.150414.1 | Last Updated 14 Apr 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid