people also ask：
baike
mobile
I ASK
QuesHub APP
QuesHub > 函数 > 过程 > 存储过程 > ASK DETAIL

What is the difference between a function and a procedure?

Scarlett Lee | 2023-05-05 12:30:33 | page views：1770
I'll answer
Earn 20 gold coins for an accepted answer.20 Earn 20 gold coins for an accepted answer.
40more
Best Answer | Search More answer on queshub>>

Harper Lee

Studied at the University of Zurich, Lives in Zurich, Switzerland.
Basic Difference. Function must return a value but in Stored Procedure it is optional( Procedure can return zero or n values). Functions can have only input parameters for it whereas Procedures can have input/output parameters . Functions can be called from Procedure whereas Procedures cannot be called from Function.
2023-05-15 12:30:33
评论(499) Helpful(122)

Benjamin Allen

QuesHub.com delivers expert answers and knowledge to you.
Basic Difference. Function must return a value but in Stored Procedure it is optional( Procedure can return zero or n values). Functions can have only input parameters for it whereas Procedures can have input/output parameters . Functions can be called from Procedure whereas Procedures cannot be called from Function.
Difference between Stored Procedure and Function in SQL Server
ORG URL>>
首页 上一页 1 NEXT  LAST
  • 0
    0
    2
    3
    4
    5
    6
    7
    8
    9
    0
    1
    2
    3
    4
    5
    6
    7
    8
    9
  • 0
    1
    2
    3
    4
    5
    6
    7
    8
    9
    0
    1
    2
    3
    4
    5
    6
    7
    8
    9
  • 0
    1
    2
    3
    4
    5
    6
    7
    8
    9
    0
    1
    2
    3
    4
    5
    6
    7
    8
    9
  • 0
    1
    2
    3
    4
    5
    6
    7
    8
    9
    0
    1
    2
    3
    4
    5
    6
    7
    8
    9
  • 0
    1
    2
    3
    4
    5
    6
    7
    8
    9
    0
    1
    2
    3
    4
    5
    6
    7
    8
    9
  • 0
    1
    2
    3
    4
    5
    6
    7
    8
    9
    0
    1
    2
    3
    4
    5
    6
    7
    8
    9
  • 0
    1
    2
    3
    4
    5
    6
    7
    8
    9
    0
    1
    2
    3
    4
    5
    6
    7
    8
    9
  • 0
    1
    2
    3
    4
    5
    6
    7
    8
    9
    0
    1
    2
    3
    4
    5
    6
    7
    8
    3

people are using QuesHub for answers.

Me Too.
RunTime:0.8306 || DBTime : 0

HOT TOPIC

ask:3,asku:1,askr:137,askz:21,askd:152,RedisW:0askR:3,askD：0 mz:hit,askU:0,askT:0askA:4