The below are the key differences between user-defined SP and system-defined SP .
S.No |
User-defined SP |
System-defined
SP |
1 |
Once
we create User defined SP in one database i.e available to only that database
directly.i.e we cannot call it from some other DB’s directly. |
System
defined sp are available in master db. These sp’s can be directly called from any db. |
2 |
UDSP will be used to fulfill the user requirements | SDSP will be used for managing sql server |
No comments:
Post a Comment