TSQL Stored Procedure Template

create proc Get_full_details (@customer_id INT) as
Select *
from [AdventureWorks2016].[Sales].[Customer]
where [CustomerID] = @customer_id;
GO