temporarytablemssql

Microsoft SQL Server project which utilizes a stored procedure in conjunction with a temporary table

Table of Contents

• Version
• Important Note
• Dependent MSSQL Function
• Prerequisite Data Types
• Prerequisite Functions
• Prerequisite Conditions
• Usage

Version

• 0.0.1

Important Note

• This project was written with SQL Server 2012 methods

Dependent MSSQL Function

• Omit Characters

Prerequisite Data Types

• bigint
• int
• nvarchar
• datetime2

Prerequisite Functions

• nullif
• ltrim
• rtrim
• getdate
• max
• replicate
• convert
• row_number
• over
• format
• dateadd
• cast

Prerequisite Conditions

• left join

Usage

• dbo.extractInsertUpdateTemporaryTable @optionMode = 'extractEntries'