search

woneuy01 / SQL

0 stars 0 forks source link

Udemy advanced sql #5

Open woneuy01 opened 3 years ago

woneuy01 commented 3 years ago

CREATE VIEW NASalesQuota AS SELECT [Name], [Group], [SalesQuota],[Bonus] FROM [AdventureWorks2012].[Sales].[SalesTerritory] A INNER JOIN Sales].[SalesPerson] B ON A.TerritoryID=B.terrytoryID WHERE [Group] LIKE 'North America'

Select * from NASalesQuota

woneuy01 commented 3 years ago

CREATE TRIGGER Demo_Trigger ON [HumanResources].[Shift] AFTER INSERT AS BEGIN PRINT 'INSERT IS NOT ALLOWED. YOU NEED APPROVAL' ROLLBACK TRANSACTION END GO

-- TEST THE TRIGGER INSERT INTO [HumanResources].[Shift] ( [Name], [StartTime], [EndTime], [ModifiedDate]) VALUES ('RAKESH2', '7', '8', getdate() ) --이걸 실행 시키면 애러 메세지가 나온다

woneuy01 commented 3 years ago

CREATE TRIGGER DEMO_DBLEVELTRIGGER ON DATABASE AFTER CREATE_TABLE AS BEGIN PRINT 'CREATION OF NEW TABKES NOT ALLOWED' ROLLBACK TRANSACTION END GO

CREATE TABLE MYDEMOTABLE(Col1 varchar(10)) --에러 메시지가 뜬다