Database Snapshots

$-$SELECT TOP $(1000)[$swat$\_$key$]$

AdventureWorks$2019$

AdventureWorksLT$2019$

Appleton

$,[$full$\_$name$]$

$,[$badge$\_$number$]$

$,[$cell$\_$number$]$

FROM $[$Appleton$].[$dbo$].[$PD$\_$ST$\_$MEMBERS$\_$TBL$]$

Database Diagrams

$$ Tables

System Tables

FileTables

External Tables

$$ Graph Tables

$$ dbo.FN$\_$RESIDENT$\_$TBL

$$dbo$.$HE$\_$CLIENT$\_$MAIN$\_$TBL

$$dbo$.$IS$\_$LS$\_$SOFTWARE$\_$TBL

$$dbo$.$PD$\_$ST$\_$MEMBERS$\_$TBL

$$dbo$.$PD$\_$WP$\_$MAIN$\_$TBL

$$ Dropped Ledger Tables

$$ Views

$$ External Resources

Synonyms

$$ Programmability

$$ Query Store

$$ Service Broker

$$ Storage

Create a new Stored Procedure of your choice against one of the tables found in this database. Use one or more parameters in your stores peocedure. Execute your procedure to create it$.($Make sure gou commit the procedure before looking for it$.)$ Execute the procedure and pass in the oarameter values. Show the T$-$SQL code that executes the new stored procedure and shows the results.