Labels

Wednesday, 23 December 2015

SQL Server - Difference between User -defined SP and System-defined SP

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