Click here to Skip to main content
11,632,778 members (82,633 online)
   

Database

 
GeneralRe: sql server 2008 Pin
Eddy Vluggen21-Jan-13 1:15
mvpEddy Vluggen21-Jan-13 1:15 
GeneralRe: sql server 2008 Pin
PIEBALDconsult21-Jan-13 4:57
memberPIEBALDconsult21-Jan-13 4:57 
AnswerRe: sql server 2008 Pin
PIEBALDconsult18-Jan-13 4:01
memberPIEBALDconsult18-Jan-13 4:01 
Questionsql server Pin
yogika17-Jan-13 19:15
memberyogika17-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 Pin
Eddy Vluggen18-Jan-13 1:37
mvpEddy Vluggen18-Jan-13 1:37 
AnswerRe: sql server Pin
Richard Deeming18-Jan-13 1:37
memberRichard Deeming18-Jan-13 1:37 
GeneralRe: sql server Pin
Eddy Vluggen18-Jan-13 2:13
mvpEddy Vluggen18-Jan-13 2:13 
GeneralRe: sql server Pin
Richard Deeming18-Jan-13 2:18
memberRichard Deeming18-Jan-13 2:18 
GeneralRe: sql server Pin
Eddy Vluggen18-Jan-13 2:22
mvpEddy Vluggen18-Jan-13 2:22 
GeneralRe: sql server Pin
PIEBALDconsult18-Jan-13 14:36
memberPIEBALDconsult18-Jan-13 14: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.150728.1 | Last Updated 27 Jul 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid