Interview Questions Answers.ORG
Interviewer And Interviewee Guide
Interviews
Quizzes
Home
Quizzes
Interviews New MS SQL Server Interviews:MS SQL Data MiningMS SQL Reporting ServicesMS SQL Server 2008MS SQL Server IndexesMS SQL Server JoinsMS SQL Server OptimizationMS SQL Server ReplicationMS SQL Server ViewsMS SQL Server XML IntegrationSQL Database ConceptsSQL Server ArchitectureSQL Server ConstraintsSQL Server CursorsSQL Server Database AdministratorSQL Server FunctionsSQL Server LocksSQL Server Service BrokerSQL Server TriggersSQL Stored ProceduresSSISTransaction Server
Copyright © 2018. All Rights Reserved
SQL Database Concepts Interview Question:
Do you know what is difference between stored procedure and user defined function?
Submitted by: AdministratorAd
It is not possible to change the table data with the use of User defined functions but you can do it by using stored procedure.
The execution of User defined function will be stopped if any error occurred in it. But in the case of Stored procedure when an error occurs the execution will ignore the error and jumps to the next statement.
We can use User defined function in XML FOR clause but we can use stored procedure in XML FOR clause.
It is not possible to make permanent changes to server environment whereas stored procedure can change some of the server environment.
User defined functions do not return output parameters while stored procedure can return output parameters.
Submitted by: Administrator
The execution of User defined function will be stopped if any error occurred in it. But in the case of Stored procedure when an error occurs the execution will ignore the error and jumps to the next statement.
We can use User defined function in XML FOR clause but we can use stored procedure in XML FOR clause.
It is not possible to make permanent changes to server environment whereas stored procedure can change some of the server environment.
User defined functions do not return output parameters while stored procedure can return output parameters.
Submitted by: Administrator
Copyright 2007-2025 by Interview Questions Answers .ORG All Rights Reserved.
https://InterviewQuestionsAnswers.ORG.

https://InterviewQuestionsAnswers.ORG.
