extractgeneratemacmssql

Microsoft SQL Server project which utilizes a stored procedure to extract and generate mac(s)

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
• smallint
• nvarchar
• datetime2

Prerequisite Functions

• nullif
• ltrim
• rtrim
• getdate
• format
• count
• substring
• len
• floor
• reverse
• charindex
• error_number
• error_line
• error_message

Prerequisite Conditions

• exists

Usage

• dbo.extractGenerateMAC @optionMode = 'extractMac'
• dbo.extractGenerateMAC @optionMode = 'generateMac', @macGenerationQuantity = 'MacGenerationQuantity'