Simple 👌 #SQL #dataengineering #dataanalytics #datascience #sqlserver #database #data #programming

preview_player
Показать описание
It is this simple to rename a stored procedure. Did you knew this ?

sp_rename'object_name' , 'new_name' - Changes the name of a user-created object in the current database. This object can be a stored procedure, table, index, column, alias data type, or Microsoft .NET Framework common language runtime (CLR) user-defined type.

🔥PLEASE LIKE and SUBSCRIBE🔥 - this will boost our motivation to create even more amazing videos.

Be a SQL HERO!

Simple 👌 #SQL #dataengineering #dataanalytics #datascience #sqlserver #database #dba #data #programming
Рекомендации по теме
Комментарии
Автор

Hey there, i feel blessed to keep in touch with you, through asking questions.
As a newbie sql learner i have a general enquiry.
I learned that a module can contain routines, procedures, or SQL commands.
What is the distinct difference between those three components.
Thanks for taking care of this.

hasanmougharbel
Автор

Will it be renamed everywhere the sp is used?

javedabdool