Sym 400- Benchmark - SQL Triggers: Introduction to Database Structures.

SYM 400 Introduction to Database Structures.




From this assignment The pictures Below will demonstrate all the steps I have taken.

, 9 WeD Google Chiome.
labagent lopescloud.geu.edu/vmDisplay?id=3763c605-8204-4134-97b5-9acbBaddc
1 0c&loginPrompt=false
7 SQLQuery.sql - EC2AMAZ-MLEISMR AdventureWorks2017 (ECZAMAZ-MLEIMR\rdp_user (52))* - Microsoft SQL Server Management Studio
File Edit View Query Project Tools Window Help
o - G- o0-URP| BNewuey BIQRARI N XPA[2-C -
§ | Adventureworks2017 - | b Becste ® v 32 8[E] ° 55 | S[@]D
et i R 5oL e e+ < I
Connect~ § ¢ declare @QOH int ‘f
[© @ EC2AMAZ-MLEISMR
(SQL Server15 ;::lgf‘:‘mmsi::" Rroduct 0oy from inserted
S W Databases set @MIN - (Select Product MIN from inserted |
@ W System Databases declare @code varchar (10
@ 1 Database Snapshots set @code -(select Product code from inserted) ‘
= @ AdventureWorks2017 51if (@QOH<@MIN -
@ 1 Database Diagrams Supdate Products
& M Tables set Product_Redrder-1
i where Produst Cods- 1
end -
@ W External Resources
@ 1 Synonyms X
@ W Programmability B Messages
@ W Service Broker Conmands compleved successfully. 7
@B W8 Secury
Storage Completion time: 2024-10-07703:52:21.7530214400:00
@ @ AdventureWorksDW2017
@ W Security
@ W Server Objects
% W Replication .
® W PolyBase N I
Ahacs O Lok Aumitabitins
< > @ Query executed successfully. EC2AMAZ-MLEISMR (15.0 RTM) ECZAMAZ-'%E(WR\MD_IU. AdventureWorks2017 00:00:00 0 rows



‘Web Virtual Machine - Google Chrome
25 labagent.lopescloud.geu.edu/vmDisplayi
SQLQuery3.sql - EC2AMAZ-MLEIIMR AdventureWorks2017 (ECZAMAZ-MLEIWR\[_@JHU (52))* - Microsoft SQL Server Management Studio

File Edit View Query Project Tools Window Help
C-0[B-u-URF Brwauey QIR XTH|2-C- -lRrpEe-
Ҥ | AdventureWorks2017 - | b Execute viegraee deo w
Object Explorer -
P Products +
cinaith (B8, Lok set ProductQon - 4 %
= @ EC2AMAZ-MLEI9MR
(SQL Server15 A Where Product Code - 1]
5 8 Databases
) 1 System Databases
¥ Database Snapshots
@ AdventureWorks2017
Database Diagrams
Tables
Views

5& 18 oy
Beral
S Resources 100% - &
& ¥ Programmability B Messages
- Service Broker -
© 1 Sorage (1 row atfected)
R M Secuny (1 xow atfected)
@ @ AdventureWorksDW2017
@ W Security Completion time: 2024-10-07704:04:26.0844784400:00
@ 9 Server Objects
@ W Replication -
@ W PolyBase 100% -
Aharsare O Hink Avsilabiling >
< > 0 © Query executed successully. EC2AMAZ-MLEIOMR (15.0RTM) EC2AMAZ-MLEIMR\rdp_us... AdventureWorks2017 00:00:00 0rows
[ Ready tn3 Col 23 Ch23 INS