Click here to Skip to main content
12,953,263 members (82,299 online)
   

Database

 
AnswerRe: Change the language for Sql Server 2008 Pin
Mycroft Holmes19-Jan-13 14:19
memberMycroft Holmes19-Jan-13 14:19 
Questionsql server 2008 Pin
Kapilkp17-Jan-13 23:25
memberKapilkp17-Jan-13 23:25 
QuestionRe: sql server 2008 Pin
Eddy Vluggen18-Jan-13 1:30
mvpEddy Vluggen18-Jan-13 1:30 
GeneralRe: sql server 2008 Pin
Kapilkp20-Jan-13 23:06
memberKapilkp20-Jan-13 23:06 
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 
AnswerRe: sql server Pin
PIEBALDconsult18-Jan-13 4:04
memberPIEBALDconsult18-Jan-13 4:04 
GeneralRe: sql server Pin
Shameel22-Jan-13 4:31
memberShameel22-Jan-13 4:31 
QuestionDo I need a pivot Query? Pin
GREG_DORIANcod16-Jan-13 10:09
memberGREG_DORIANcod16-Jan-13 10:09 
AnswerRe: Do I need a pivot Query? Pin
Mycroft Holmes16-Jan-13 19:36
memberMycroft Holmes16-Jan-13 19:36 
GeneralRe: Do I need a pivot Query? Pin
GREG_DORIANcod17-Jan-13 1:59
memberGREG_DORIANcod17-Jan-13 1:59 
AnswerRe: Do I need a pivot Query? Pin
Jörgen Andersson21-Jan-13 8:58
memberJörgen Andersson21-Jan-13 8:58 
QuestionTotals of each transaction type Pin
Richard.Berry10015-Jan-13 21:38
memberRichard.Berry10015-Jan-13 21:38 
AnswerRe: Totals of each transaction type Pin
Mycroft Holmes15-Jan-13 22:57
memberMycroft Holmes15-Jan-13 22:57 
GeneralRe: Totals of each transaction type Pin
Richard.Berry10016-Jan-13 0:36
memberRichard.Berry10016-Jan-13 0:36 
GeneralRe: Totals of each transaction type Pin
PIEBALDconsult16-Jan-13 3:42
memberPIEBALDconsult16-Jan-13 3:42 
GeneralRe: Totals of each transaction type Pin
Richard.Berry10016-Jan-13 5:36
memberRichard.Berry10016-Jan-13 5:36 

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.


Advertise | Privacy | Mobile
Web01 | 2.8.170525.1 | Last Updated 26 May 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid