Non-SNS

Table of contents

1. Terminology
2. Basics
   1. Hierarchy
   2. Removing a table
   3. Removing a row entry from a table
   4. Running store proc
3. Views
   1. Running a View in SSMS (from Microsoft)
   2. Altering a a View SSMS (from Microsoft)
   3. Altering View using techniques (i.e. CONVERT, ROUND, NUMERIC, CASE WHEN, VARCHAR, THEN, END, AS)

---

Terminology

1. SSMS: Microsoft’s SQL Server Management Studio (we’re using 17)

Basics

Hierarchy

Server > SQL Server Agent | Database(s) > View | Table(s) | Programmability > Column(s) | Keys | Indexes | Constraints

Removing a table

TRUNCATE TABLE [Database Name].[dbo].[Table Name]

Removing a row entry from a table

DELETE [Database Name].[dbo].Table_Name WHERE [Column1] = 'stuff1' AND [CurDate] = CONVERT(VARCHAR(8), GETDATE(), 112)

-- CurDate is matching date cases YYYYMMDD

Running store proc

EXEC [Database Name].[dbo].[Store Proc Name] @Input1='input1', @Input2='input2'

Views

Running a View in SSMS (from Microsoft)

Right click on view -> Select Top 1000 Rows

Altering a a View SSMS (from Microsoft)

Right Script View as -> ALTER To -> Edit SQL -> Top left "Execute"

Altering View using techniques (i.e. CONVERT, ROUND, NUMERIC, CASE WHEN, VARCHAR, THEN, END, AS)

---

Table of contents