OliverRC

;WITH cte_1 AS
(
),cte_2 AS
(
)

OliverRC

DECLARE @ProductTotals TABLE
(
  ProductID int, 
  Revenue money
)

OliverRC

IF EXISTS(SELECT * FROM sysobjects where id = object_id(N'<schema>.<procedureName>') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
DROP PROCEDURE <schema>.<procedureName>
GO

CREATE PROCEDURE <schema>.<procedureName> <@parameters

AS 
    BEGIN
        
    END

OliverRC

IF EXISTS(SELECT * FROM sysobjects where id = object_id(N'<schema>.<view>') and OBJECTPROPERTY(id, N'IsView') = 1)
DROP VIEW <schema>.<view>
GO

CREATE VIEW dbo.vw_Mon_Casino

AS

GO

OliverRC

Add-Migration {name}

OliverRC

USE master
GO

--Run to varify backup and view Logical and Physical Names
RESTORE FILELISTONLY
   FROM disk = 'C:\<backfile>'

--Run once you are happy with everything
RESTORE DATABASE <databasename>
   FROM disk = 'C:\<backfile>'

OliverRC

IF EXISTS(SELECT * FROM sysobjects where id = object_id(N'<schema>.<view>') and OBJECTPROPERTY(id, N'IsView') = 1)
DROP VIEW <schema>.<view>
GO

CREATE VIEW dbo.vw_Mon_Casino

AS

GO

OliverRC

IF EXISTS(SELECT * FROM sysobjects where id = object_id(N'<schema>.<procedureName>') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
DROP PROCEDURE <schema>.<procedureName>
GO

CREATE PROCEDURE <schema>.<procedureName> <@parameters

AS 
    BEGIN
        
    END

OliverRC

%TEMP%\Temporary ASP.NET Files
C:\Windows\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files
C:\Windows\Microsoft.NET\Framework\v4.0.30319\Temporary ASP.NET Files
C:\Windows\Microsoft.NET\Framework64\v2.0.50727\Temporary ASP.NET Files
C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Temporary ASP.NET Files

OliverRC

<div class="navbar navbar-default" role="navigation">
   <div class="container">
     <div class="navbar-header">
       <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-collapse">
         <span class="sr-only">Toggle navigation</span>
         <span class="icon-bar"></span>
         <span class="icon-bar"></span>
         <span class="icon-bar"></span>
       </button>
       <a class="navbar-brand" href="#">Brand Name</a>