Click here to Skip to main content
12,357,409 members (72,035 online)
   

Database

 
AnswerRe: created tables not dropped in a transaction rollback Pin
Eddy Vluggen21-Jan-13 2:06
mvpEddy Vluggen21-Jan-13 2:06 
AnswerRe: created tables not dropped in a transaction rollback Pin
Shameel21-Jan-13 22:08
memberShameel21-Jan-13 22:08 
GeneralRe: created tables not dropped in a transaction rollback Pin
jschell22-Jan-13 8:16
memberjschell22-Jan-13 8:16 
GeneralRe: created tables not dropped in a transaction rollback Pin
Shameel22-Jan-13 23:46
memberShameel22-Jan-13 23:46 
QuestionChange the language for Sql Server 2008 Pin
Thaer Hamael19-Jan-13 1:27
memberThaer Hamael19-Jan-13 1:27 
AnswerRe: Change the language for Sql Server 2008 Pin
PIEBALDconsult19-Jan-13 5:29
memberPIEBALDconsult19-Jan-13 5:29 
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 
QuestionCustomize color coding in SQL editor window Pin
biop.codeproject15-Jan-13 20:04
memberbiop.codeproject15-Jan-13 20:04 
AnswerRe: Customize color coding in SQL editor window Pin
Mycroft Holmes15-Jan-13 22:51
memberMycroft Holmes15-Jan-13 22:51 
GeneralMessage Removed Pin
biop.codeproject16-Jan-13 19:26
memberbiop.codeproject16-Jan-13 19:26 
GeneralRe: Customize color coding in SQL editor window Pin
Mycroft Holmes16-Jan-13 19:34
memberMycroft Holmes16-Jan-13 19:34 
GeneralRe: Customize color coding in SQL editor window Pin
Shameel22-Jan-13 4:41
memberShameel22-Jan-13 4:41 
Questionquery.. Pin
vishal.v.patil14-Jan-13 17:49
membervishal.v.patil14-Jan-13 17:49 
AnswerRe: query.. Pin
Mycroft Holmes14-Jan-13 17:54
memberMycroft Holmes14-Jan-13 17:54 
GeneralRe: query.. Pin
vishal.v.patil14-Jan-13 18:21
membervishal.v.patil14-Jan-13 18:21 
GeneralRe: query.. Pin
Blue_Boy15-Jan-13 3:11
memberBlue_Boy15-Jan-13 3:11 
QuestionBuilding dictionary translation Pin
Y@ssco14-Jan-13 16:19
memberY@ssco14-Jan-13 16:19 
AnswerRe: Building dictionary translation Pin
Mycroft Holmes14-Jan-13 17:52
memberMycroft Holmes14-Jan-13 17:52 
GeneralRe: Building dictionary translation Pin
Y@ssco14-Jan-13 18:41
memberY@ssco14-Jan-13 18:41 
GeneralRe: Building dictionary translation Pin
Mycroft Holmes14-Jan-13 18:52
memberMycroft Holmes14-Jan-13 18:52 
GeneralRe: Building dictionary translation Pin
djj5515-Jan-13 1:51
memberdjj5515-Jan-13 1:51 
GeneralRe: Building dictionary translation Pin
Y@ssco15-Jan-13 18:23
memberY@ssco15-Jan-13 18:23 
AnswerRe: Building dictionary translation Pin
Eddy Vluggen16-Jan-13 2:41
mvpEddy Vluggen16-Jan-13 2:41 
Questionembedding sql server express in application Pin
Danzy8313-Jan-13 16:48
memberDanzy8313-Jan-13 16:48 
AnswerRe: embedding sql server express in application Pin
PIEBALDconsult13-Jan-13 17:02
memberPIEBALDconsult13-Jan-13 17:02 
AnswerRe: embedding sql server express in application Pin
Eddy Vluggen14-Jan-13 2:07
mvpEddy Vluggen14-Jan-13 2:07 

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.160621.1 | Last Updated 29 Jun 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid