SQL Server Connector – Azure API App – Part 2

SQLServerConnectorAzureAPIAppPart2.sql

CREATE SCHEMA [Test]
GO

CREATE TABLE Test.CustomerA (
	CustomerID int IDENTITY(1,1) NOT NULL,
	FirstName nvarchar(25) NOT NULL,
	LastName nvarchar(25) NOT NULL,
	CompanyName nvarchar(100) NOT NULL,
	Verified bit NOT NULL,
	NeedToContact bit NOT NULL
)
GO

INSERT INTO Test.CustomerA
           (FirstName
           ,LastName
           ,CompanyName
		   ,Verified
		   ,NeedToContact)
     VALUES
           ('Orlando','Gee','A Bike Store',0,0),
		   ('Keith','Harris','Progressive Sports',1,1),
		   ('Donna','Carreras','Advanced Bike Components',1,0),
		   ('Janet','Gates','Modular Cycle Systems',0,1),
		   ('Lucy','Harrington','Metropolitan Sports Supply',1,1)
GO

ALTER PROCEDURE Test.GetCustomers
@Output int = NULL OUTPUT
AS
BEGIN
	SET NOCOUNT ON;

	SET @Output = 3
END
GO