Click here to Skip to main content
       

Database

 
AnswerRe: Change the language for Sql Server 2008 PinmemberMycroft Holmes19-Jan-13 14:19 
Questionsql server 2008 PinmemberKapilkp17-Jan-13 23:25 
QuestionRe: sql server 2008 PinmvpEddy Vluggen18-Jan-13 1:30 
GeneralRe: sql server 2008 PinmemberKapilkp20-Jan-13 23:06 
GeneralRe: sql server 2008 PinmvpEddy Vluggen21-Jan-13 1:15 
GeneralRe: sql server 2008 PinmemberPIEBALDconsult21-Jan-13 4:57 
AnswerRe: sql server 2008 PinmemberPIEBALDconsult18-Jan-13 4:01 
Questionsql server Pinmemberyogika17-Jan-13 19: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 1:37 
AnswerRe: sql server PinmemberRichard Deeming18-Jan-13 1:37 
GeneralRe: sql server PinmvpEddy Vluggen18-Jan-13 2:13 
GeneralRe: sql server PinmemberRichard Deeming18-Jan-13 2:18 
GeneralRe: sql server PinmvpEddy Vluggen18-Jan-13 2:22 
GeneralRe: sql server PinmemberPIEBALDconsult18-Jan-13 14:36 
AnswerRe: sql server PinmemberPIEBALDconsult18-Jan-13 4:04 
GeneralRe: sql server PinmemberShameel22-Jan-13 4:31 
QuestionDo I need a pivot Query? PinmemberGREG_DORIANcod16-Jan-13 10:09 
AnswerRe: Do I need a pivot Query? PinmemberMycroft Holmes16-Jan-13 19:36 
GeneralRe: Do I need a pivot Query? PinmemberGREG_DORIANcod17-Jan-13 1:59 
AnswerRe: Do I need a pivot Query? PinmemberJörgen Andersson21-Jan-13 8:58 
QuestionTotals of each transaction type PinmemberRichard.Berry10015-Jan-13 21:38 
AnswerRe: Totals of each transaction type PinmemberMycroft Holmes15-Jan-13 22:57 
GeneralRe: Totals of each transaction type PinmemberRichard.Berry10016-Jan-13 0:36 
GeneralRe: Totals of each transaction type PinmemberPIEBALDconsult16-Jan-13 3:42 
GeneralRe: Totals of each transaction type PinmemberRichard.Berry10016-Jan-13 5: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
Web03 | 2.8.140926.1 | Last Updated 30 Sep 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid