SQL Tutorial 17- Create, Alter and Drop Procedure

Learn SQL, How to use Create, Alter, and Drop Procedures. #sql, #rdbms, #table, #amitchandakda #interviewquestions #interview #index

SQL Tutorial 17- Create, Alter and Drop Procedure

Definition Source: Google Search, Wikipedia, IBM, W3School, ChatGPT

00:00 Introduction
00:30 What is a Procedure
02:30 Create Procedure
08:00 Debug Procedure
12:00 Alter Procedure
15:45 Drop Procedure

SQL Tutorial 16- Window Functions- Lead, Lag, First_value, Last_value using over and Partition By

create procedure select_sales
as
Begin
select * from sales;
end;

exec select_sales

create procedure select_sales1 @item int
as
Begin
select * from sales where item_id = @item;
end;

exec select_sales1 11

create procedure select_sales2 @brand varchar , @category varchar
as
Begin
select * from sales s
inner join item i on (s.Item_ID = i.Item_Id)
end;

alter procedure select_sales2 @brand varchar , @category varchar
as
Begin
select * from sales s
inner join item i on (s.Item_ID = i.Item_Id)
end;

exec select_sales2 'Brand 1' , 'Category 1'

select * from sales s
inner join item i on (s.Item_ID = i.Item_Id)

alter procedure select_sales2 @brand varchar , @category varchar
as
Begin
select * from sales s
inner join item i on (s.Item_ID = i.Item_Id)
end;

exec select_sales2 'Brand 1' , 'Category 1'

alter procedure select_sales2 @brand varchar , @category varchar
as
Begin
select * from sales s
inner join item i on (s.Item_ID = i.Item_Id)
end;

alter procedure select_sales2 @brand varchar(50) , @category varchar(50)
as
Begin
select * from sales s
inner join item i on (s.Item_ID = i.Item_Id)
end;

exec select_sales2 'Brand 1' , 'Category 1'

drop procedure select_sales2

exec select_sales2 'Brand 1' , 'Category 1'

-~-~~-~~~-~~-~-
Please watch: "Microsoft Power BI Tutorial For Beginners✨ | Power BI Full Course 2023 | Learn Power BI"
-~-~~-~~~-~~-~-