Skip to content
Permalink

Comparing changes

Choose two branches to see what’s changed or to start a new pull request. If you need to, you can also or learn more about diff comparisons.

Open a pull request

Create a new pull request by comparing changes across two branches. If you need to, you can also . Learn more about diff comparisons here.
base repository: microsoft/sql-server-samples
Failed to load repositories. Confirm that selected base ref is valid, then try again.
Loading
base: master
Choose a base ref
...
head repository: heaivilin/sql-server-samples
Failed to load repositories. Confirm that selected head ref is valid, then try again.
Loading
compare: master
Choose a head ref
Can’t automatically merge. Don’t worry, you can still create the pull request.
  • 13 commits
  • 45 files changed
  • 2 contributors

Commits on Mar 24, 2022

  1. auto build

    @heaivilin
    heaivilin authored Mar 24, 2022
    Copy the full SHA
    7f965f7 View commit details

  2. update #1

    @heaivilin
    heaivilin committed Mar 24, 2022
    Copy the full SHA
    d76efd2 View commit details

  3. hoping

    @heaivilin
    heaivilin authored Mar 24, 2022
    Copy the full SHA
    93be597 View commit details

  4. hope 2

    @heaivilin
    heaivilin authored Mar 24, 2022
    Copy the full SHA
    6734d7f View commit details

  5. Merge branch 'master' of https://github.com/heaivilin/sql-server-samples

    @heaivilin
    heaivilin committed Mar 24, 2022
    Copy the full SHA
    d0ee14e View commit details

  6. fix crap

    @heaivilin
    heaivilin committed Mar 24, 2022
    Copy the full SHA
    4ed4ce5 View commit details

  7. bob

    @heaivilin
    heaivilin committed Mar 24, 2022
    Copy the full SHA
    b6c7db3 View commit details

  8. fix bob

    @heaivilin
    heaivilin committed Mar 24, 2022
    Copy the full SHA
    4d9b0f9 View commit details

Commits on Sep 18, 2022

  1. auto build test

    @heaivilin
    heaivilin committed Sep 18, 2022
    Copy the full SHA
    f43c445 View commit details

  2. Update WideWorldImporters.sqlproj

    @heaivilin
    heaivilin committed Sep 18, 2022
    Copy the full SHA
    df8a7c2 View commit details

  3. Adding Northwinds

    @heaivilin
    heaivilin committed Sep 18, 2022
    Copy the full SHA
    80e3b9e View commit details

  4. Update msbuild.yml

    @heaivilin
    heaivilin authored Sep 18, 2022
    Copy the full SHA
    9bc5f09 View commit details

  5. Merge branch 'master' of https://github.com/heaivilin/sql-server-samples

    @heaivilin
    heaivilin committed Sep 18, 2022
    Copy the full SHA
    93c6e3b View commit details
Showing with 860 additions and 24 deletions.
  1. +36 −0 .github/workflows/msbuild.yml
  2. +27 −0 samples/databases/Northwinds/Northwinds/Northwinds.sln
  3. +280 −0 samples/databases/Northwinds/Northwinds/Northwinds.sqlproj
  4. +16 −0 samples/databases/Northwinds/Northwinds/PublishProfiles/DEV.publish.xml
  5. +2 −0 samples/databases/Northwinds/Northwinds/Security/Schema/SSDT.sql
  6. +7 −0 samples/databases/Northwinds/Northwinds/dbo/Stored Procedures/CustOrderHist.sql
  7. +10 −0 samples/databases/Northwinds/Northwinds/dbo/Stored Procedures/CustOrdersDetail.sql
  8. +10 −0 samples/databases/Northwinds/Northwinds/dbo/Stored Procedures/CustOrdersOrders.sql
  9. +8 −0 samples/databases/Northwinds/Northwinds/dbo/Stored Procedures/Employee Sales by Country.sql
  10. +6 −0 samples/databases/Northwinds/Northwinds/dbo/Stored Procedures/Sales by Year.sql
  11. +18 −0 samples/databases/Northwinds/Northwinds/dbo/Stored Procedures/SalesByCategory.sql
  12. +6 −0 samples/databases/Northwinds/Northwinds/dbo/Stored Procedures/Ten Most Expensive Products.sql
  13. +13 −0 samples/databases/Northwinds/Northwinds/dbo/Tables/Categories.sql
  14. +8 −0 samples/databases/Northwinds/Northwinds/dbo/Tables/CustomerCustomerDemo.sql
  15. +6 −0 samples/databases/Northwinds/Northwinds/dbo/Tables/CustomerDemographics.sql
  16. +35 −0 samples/databases/Northwinds/Northwinds/dbo/Tables/Customers.sql
  17. +8 −0 samples/databases/Northwinds/Northwinds/dbo/Tables/EmployeeTerritories.sql
  18. +34 −0 samples/databases/Northwinds/Northwinds/dbo/Tables/Employees.sql
  19. +34 −0 samples/databases/Northwinds/Northwinds/dbo/Tables/Order Details.sql
  20. +61 −0 samples/databases/Northwinds/Northwinds/dbo/Tables/Orders.sql
  21. +45 −0 samples/databases/Northwinds/Northwinds/dbo/Tables/Products.sql
  22. +6 −0 samples/databases/Northwinds/Northwinds/dbo/Tables/Region.sql
  23. +7 −0 samples/databases/Northwinds/Northwinds/dbo/Tables/Shippers.sql
  24. +26 −0 samples/databases/Northwinds/Northwinds/dbo/Tables/Suppliers.sql
  25. +8 −0 samples/databases/Northwinds/Northwinds/dbo/Tables/Territories.sql
  26. +5 −0 samples/databases/Northwinds/Northwinds/dbo/Views/Alphabetical list of products.sql
  27. +5 −0 samples/databases/Northwinds/Northwinds/dbo/Views/Category Sales for 1997.sql
  28. +6 −0 samples/databases/Northwinds/Northwinds/dbo/Views/Current Product List.sql
  29. +8 −0 samples/databases/Northwinds/Northwinds/dbo/Views/Customer and Suppliers by City.sql
  30. +19 −0 samples/databases/Northwinds/Northwinds/dbo/Views/Invoices.sql
  31. +7 −0 samples/databases/Northwinds/Northwinds/dbo/Views/Order Details Extended.sql
  32. +5 −0 samples/databases/Northwinds/Northwinds/dbo/Views/Order Subtotals.sql
  33. +7 −0 samples/databases/Northwinds/Northwinds/dbo/Views/Orders Qry.sql
  34. +10 −0 samples/databases/Northwinds/Northwinds/dbo/Views/Product Sales for 1997.sql
  35. +6 −0 samples/databases/Northwinds/Northwinds/dbo/Views/Products Above Average Price.sql
  36. +6 −0 samples/databases/Northwinds/Northwinds/dbo/Views/Products by Category.sql
  37. +5 −0 samples/databases/Northwinds/Northwinds/dbo/Views/Quarterly Orders.sql
  38. +7 −0 samples/databases/Northwinds/Northwinds/dbo/Views/Sales Totals by Amount.sql
  39. +12 −0 samples/databases/Northwinds/Northwinds/dbo/Views/Sales by Category.sql
  40. +6 −0 samples/databases/Northwinds/Northwinds/dbo/Views/Summary of Sales by Quarter.sql
  41. +6 −0 samples/databases/Northwinds/Northwinds/dbo/Views/Summary of Sales by Year.sql
  42. +5 −21 samples/databases/wide-world-importers/wwi-sample.sln
  43. +5 −0 samples/databases/wide-world-importers/wwi-ssdt/wwi-ssdt/Sales/Tables/bob.sql
  44. +1 −1 samples/databases/wide-world-importers/wwi-ssdt/wwi-ssdt/Security/Application.sql
  45. +12 −2 samples/databases/wide-world-importers/wwi-ssdt/wwi-ssdt/WideWorldImporters.sqlproj
36 changes: 36 additions & 0 deletions .github/workflows/msbuild.yml
View file
Original file line number Diff line number Diff line change
@@ -0,0 +1,36 @@
name: MSBuild

on:
push:
branches: [ master ]
pull_request:
branches: [ master ]

env:
# Path to the solution file relative to the root of the project.
SOLUTION_FILE_PATH: .\samples\databases\Northwinds\Northwinds

# Configuration type to build.
# You can convert this to a build matrix if you need coverage of multiple configuration types.
# https://docs.github.com/actions/learn-github-actions/managing-complex-workflows#using-a-build-matrix
BUILD_CONFIGURATION: debug

jobs:
build:
runs-on: windows-latest

steps:
- uses: actions/checkout@v2

- name: Add MSBuild to PATH
uses: microsoft/setup-msbuild@v1.0.2

- name: Restore NuGet packages
working-directory: ${{env.GITHUB_WORKSPACE}}
run: nuget restore ${{env.SOLUTION_FILE_PATH}}

- name: Build
working-directory: ${{env.GITHUB_WORKSPACE}}
# Add additional options to the MSBuild command line here (like platform or verbosity level).
# See https://docs.microsoft.com/visualstudio/msbuild/msbuild-command-line-reference
run: msbuild /m /p:Configuration=${{env.BUILD_CONFIGURATION}} ${{env.SOLUTION_FILE_PATH}}
27 changes: 27 additions & 0 deletions samples/databases/Northwinds/Northwinds/Northwinds.sln
View file
Original file line number Diff line number Diff line change
@@ -0,0 +1,27 @@

Microsoft Visual Studio Solution File, Format Version 12.00
# Visual Studio Version 16
VisualStudioVersion = 16.0.32802.440
MinimumVisualStudioVersion = 10.0.40219.1
Project("{00D1A9C2-B5F0-4AF3-8072-F6C62B433612}") = "Northwinds", "Northwinds.sqlproj", "{9F51212F-6CE4-4C31-B4CA-449922AE5164}"
EndProject
Global
GlobalSection(SolutionConfigurationPlatforms) = preSolution
Debug|Any CPU = Debug|Any CPU
Release|Any CPU = Release|Any CPU
EndGlobalSection
GlobalSection(ProjectConfigurationPlatforms) = postSolution
{9F51212F-6CE4-4C31-B4CA-449922AE5164}.Debug|Any CPU.ActiveCfg = Debug|Any CPU
{9F51212F-6CE4-4C31-B4CA-449922AE5164}.Debug|Any CPU.Build.0 = Debug|Any CPU
{9F51212F-6CE4-4C31-B4CA-449922AE5164}.Debug|Any CPU.Deploy.0 = Debug|Any CPU
{9F51212F-6CE4-4C31-B4CA-449922AE5164}.Release|Any CPU.ActiveCfg = Release|Any CPU
{9F51212F-6CE4-4C31-B4CA-449922AE5164}.Release|Any CPU.Build.0 = Release|Any CPU
{9F51212F-6CE4-4C31-B4CA-449922AE5164}.Release|Any CPU.Deploy.0 = Release|Any CPU
EndGlobalSection
GlobalSection(SolutionProperties) = preSolution
HideSolutionNode = FALSE
EndGlobalSection
GlobalSection(ExtensibilityGlobals) = postSolution
SolutionGuid = {33A82945-A28C-4FBE-9458-3CCB8EE6AB1F}
EndGlobalSection
EndGlobal
280 changes: 280 additions & 0 deletions samples/databases/Northwinds/Northwinds/Northwinds.sqlproj
View file
Original file line number Diff line number Diff line change
@@ -0,0 +1,280 @@
<?xml version="1.0" encoding="utf-8"?>
<Project DefaultTargets="Build" xmlns="http://schemas.microsoft.com/developer/msbuild/2003" ToolsVersion="4.0">
<PropertyGroup>
<Configuration Condition=" '$(Configuration)' == '' ">Debug</Configuration>
<Platform Condition=" '$(Platform)' == '' ">AnyCPU</Platform>
<Name>Northwinds</Name>
<SchemaVersion>2.0</SchemaVersion>
<ProjectVersion>4.1</ProjectVersion>
<ProjectGuid>{9f51212f-6ce4-4c31-b4ca-449922ae5164}</ProjectGuid>
<DSP>Microsoft.Data.Tools.Schema.Sql.Sql150DatabaseSchemaProvider</DSP>
<OutputType>Database</OutputType>
<RootPath>
</RootPath>
<RootNamespace>Northwinds</RootNamespace>
<AssemblyName>Northwinds</AssemblyName>
<ModelCollation>1033,CI</ModelCollation>
<DefaultFileStructure>BySchemaAndSchemaType</DefaultFileStructure>
<DeployToDatabase>True</DeployToDatabase>
<TargetFrameworkVersion>v4.5</TargetFrameworkVersion>
<TargetLanguage>CS</TargetLanguage>
<AppDesignerFolder>Properties</AppDesignerFolder>
<SqlServerVerification>False</SqlServerVerification>
<IncludeCompositeObjects>True</IncludeCompositeObjects>
<TargetDatabaseSet>True</TargetDatabaseSet>
<DefaultCollation>SQL_Latin1_General_CP1_CI_AS</DefaultCollation>
<AnsiNulls>False</AnsiNulls>
<QuotedIdentifier>False</QuotedIdentifier>
<QueryStoreCaptureMode>Auto</QueryStoreCaptureMode>
<QueryStoreDesiredState>ReadWrite</QueryStoreDesiredState>
<QueryStoreFlushInterval>900</QueryStoreFlushInterval>
<QueryStoreStatsInterval>60</QueryStoreStatsInterval>
<QueryStoreMaxPlansPerQuery>200</QueryStoreMaxPlansPerQuery>
<QueryStoreStaleQueryThreshold>30</QueryStoreStaleQueryThreshold>
<QueryStoreMaxStorageSize>100</QueryStoreMaxStorageSize>
<DbScopedConfigLegacyCardinalityEstimation>Off</DbScopedConfigLegacyCardinalityEstimation>
<DbScopedConfigMaxDOP>8</DbScopedConfigMaxDOP>
<DbScopedConfigParameterSniffing>On</DbScopedConfigParameterSniffing>
<DbScopedConfigOptimizerHotfixes>Off</DbScopedConfigOptimizerHotfixes>
<DelayedDurability>DISABLED</DelayedDurability>
<AutoCreateStatisticsIncremental>False</AutoCreateStatisticsIncremental>
<MemoryOptimizedElevateToSnapshot>False</MemoryOptimizedElevateToSnapshot>
<Containment>None</Containment>
<IsNestedTriggersOn>True</IsNestedTriggersOn>
<IsTransformNoiseWordsOn>False</IsTransformNoiseWordsOn>
<TwoDigitYearCutoff>2049</TwoDigitYearCutoff>
<NonTransactedFileStreamAccess>OFF</NonTransactedFileStreamAccess>
<TargetRecoveryTimePeriod>60</TargetRecoveryTimePeriod>
<TargetRecoveryTimeUnit>SECONDS</TargetRecoveryTimeUnit>
<IsChangeTrackingOn>False</IsChangeTrackingOn>
<IsChangeTrackingAutoCleanupOn>True</IsChangeTrackingAutoCleanupOn>
<ChangeTrackingRetentionPeriod>2</ChangeTrackingRetentionPeriod>
<ChangeTrackingRetentionUnit>Days</ChangeTrackingRetentionUnit>
<IsEncryptionOn>True</IsEncryptionOn>
<IsBrokerPriorityHonored>False</IsBrokerPriorityHonored>
<Trustworthy>False</Trustworthy>
<AutoUpdateStatisticsAsynchronously>False</AutoUpdateStatisticsAsynchronously>
<PageVerify>CHECKSUM</PageVerify>
<ServiceBrokerOption>EnableBroker</ServiceBrokerOption>
<DateCorrelationOptimizationOn>False</DateCorrelationOptimizationOn>
<Parameterization>FORCED</Parameterization>
<AllowSnapshotIsolation>True</AllowSnapshotIsolation>
<ReadCommittedSnapshot>False</ReadCommittedSnapshot>
<VardecimalStorageFormatOn>True</VardecimalStorageFormatOn>
<SupplementalLoggingOn>False</SupplementalLoggingOn>
<CompatibilityMode>150</CompatibilityMode>
<AnsiNullDefault>False</AnsiNullDefault>
<AnsiPadding>False</AnsiPadding>
<AnsiWarnings>False</AnsiWarnings>
<ArithAbort>False</ArithAbort>
<ConcatNullYieldsNull>False</ConcatNullYieldsNull>
<NumericRoundAbort>False</NumericRoundAbort>
<RecursiveTriggersEnabled>False</RecursiveTriggersEnabled>
<DatabaseChaining>False</DatabaseChaining>
<DatabaseState>ONLINE</DatabaseState>
<CloseCursorOnCommitEnabled>False</CloseCursorOnCommitEnabled>
<DefaultCursor>GLOBAL</DefaultCursor>
<AutoClose>False</AutoClose>
<AutoCreateStatistics>True</AutoCreateStatistics>
<AutoShrink>False</AutoShrink>
<AutoUpdateStatistics>True</AutoUpdateStatistics>
<TornPageDetection>False</TornPageDetection>
<DatabaseAccess>MULTI_USER</DatabaseAccess>
<Recovery>SIMPLE</Recovery>
<EnableFullTextSearch>True</EnableFullTextSearch>
<DefaultFilegroup>PRIMARY</DefaultFilegroup>
</PropertyGroup>
<PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Release|AnyCPU' ">
<OutputPath>bin\Release\</OutputPath>
<BuildScriptName>$(MSBuildProjectName).sql</BuildScriptName>
<TreatWarningsAsErrors>False</TreatWarningsAsErrors>
<DebugType>pdbonly</DebugType>
<Optimize>true</Optimize>
<DefineDebug>false</DefineDebug>
<DefineTrace>true</DefineTrace>
<ErrorReport>prompt</ErrorReport>
<WarningLevel>4</WarningLevel>
</PropertyGroup>
<PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' ">
<OutputPath>bin\Debug\</OutputPath>
<BuildScriptName>$(MSBuildProjectName).sql</BuildScriptName>
<TreatWarningsAsErrors>false</TreatWarningsAsErrors>
<DebugSymbols>true</DebugSymbols>
<DebugType>full</DebugType>
<Optimize>false</Optimize>
<DefineDebug>true</DefineDebug>
<DefineTrace>true</DefineTrace>
<ErrorReport>prompt</ErrorReport>
<WarningLevel>4</WarningLevel>
<CatalogCollation>SQL_Latin1_General_CP1_CI_AS</CatalogCollation>
<DataRetentionEnabled>False</DataRetentionEnabled>
</PropertyGroup>
<PropertyGroup>
<VisualStudioVersion Condition="'$(VisualStudioVersion)' == ''">11.0</VisualStudioVersion>
<!-- Default to the v11.0 targets path if the targets file for the current VS version is not found -->
<SSDTExists Condition="Exists('$(MSBuildExtensionsPath)\Microsoft\VisualStudio\v$(VisualStudioVersion)\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets')">True</SSDTExists>
<VisualStudioVersion Condition="'$(SSDTExists)' == ''">11.0</VisualStudioVersion>
</PropertyGroup>
<Import Condition="'$(SQLDBExtensionsRefPath)' != ''" Project="$(SQLDBExtensionsRefPath)\Microsoft.Data.Tools.Schema.SqlTasks.targets" />
<Import Condition="'$(SQLDBExtensionsRefPath)' == ''" Project="$(MSBuildExtensionsPath)\Microsoft\VisualStudio\v$(VisualStudioVersion)\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets" />
<ItemGroup>
<Folder Include="Properties" />
<Folder Include="dbo\" />
<Folder Include="dbo\Tables\" />
<Folder Include="dbo\Views\" />
<Folder Include="dbo\Stored Procedures\" />
<Folder Include="PublishProfiles" />
<Folder Include="Security" />
<Folder Include="Security\Schema" />
</ItemGroup>
<ItemGroup>
<Build Include="dbo\Tables\CustomerCustomerDemo.sql">
<AnsiNulls>On</AnsiNulls>
<QuotedIdentifier>On</QuotedIdentifier>
</Build>
<Build Include="dbo\Tables\CustomerDemographics.sql">
<AnsiNulls>On</AnsiNulls>
<QuotedIdentifier>On</QuotedIdentifier>
</Build>
<Build Include="dbo\Tables\Region.sql">
<AnsiNulls>On</AnsiNulls>
<QuotedIdentifier>On</QuotedIdentifier>
</Build>
<Build Include="dbo\Tables\Territories.sql">
<AnsiNulls>On</AnsiNulls>
<QuotedIdentifier>On</QuotedIdentifier>
</Build>
<Build Include="dbo\Tables\EmployeeTerritories.sql">
<AnsiNulls>On</AnsiNulls>
<QuotedIdentifier>On</QuotedIdentifier>
</Build>
<Build Include="dbo\Tables\Employees.sql">
<AnsiNulls>On</AnsiNulls>
<QuotedIdentifier>On</QuotedIdentifier>
</Build>
<Build Include="dbo\Tables\Categories.sql">
<AnsiNulls>On</AnsiNulls>
<QuotedIdentifier>On</QuotedIdentifier>
</Build>
<Build Include="dbo\Tables\Customers.sql">
<AnsiNulls>On</AnsiNulls>
<QuotedIdentifier>On</QuotedIdentifier>
</Build>
<Build Include="dbo\Tables\Shippers.sql">
<AnsiNulls>On</AnsiNulls>
<QuotedIdentifier>On</QuotedIdentifier>
</Build>
<Build Include="dbo\Tables\Suppliers.sql">
<AnsiNulls>On</AnsiNulls>
<QuotedIdentifier>On</QuotedIdentifier>
</Build>
<Build Include="dbo\Tables\Orders.sql">
<AnsiNulls>On</AnsiNulls>
<QuotedIdentifier>On</QuotedIdentifier>
</Build>
<Build Include="dbo\Tables\Products.sql">
<AnsiNulls>On</AnsiNulls>
<QuotedIdentifier>On</QuotedIdentifier>
</Build>
<Build Include="dbo\Tables\Order Details.sql">
<AnsiNulls>On</AnsiNulls>
<QuotedIdentifier>On</QuotedIdentifier>
</Build>
<Build Include="dbo\Views\Customer and Suppliers by City.sql">
<AnsiNulls>On</AnsiNulls>
<QuotedIdentifier>On</QuotedIdentifier>
</Build>
<Build Include="dbo\Views\Alphabetical list of products.sql">
<AnsiNulls>On</AnsiNulls>
<QuotedIdentifier>On</QuotedIdentifier>
</Build>
<Build Include="dbo\Views\Current Product List.sql">
<AnsiNulls>On</AnsiNulls>
<QuotedIdentifier>On</QuotedIdentifier>
</Build>
<Build Include="dbo\Views\Orders Qry.sql">
<AnsiNulls>On</AnsiNulls>
<QuotedIdentifier>On</QuotedIdentifier>
</Build>
<Build Include="dbo\Views\Products Above Average Price.sql">
<AnsiNulls>On</AnsiNulls>
<QuotedIdentifier>On</QuotedIdentifier>
</Build>
<Build Include="dbo\Views\Products by Category.sql">
<AnsiNulls>On</AnsiNulls>
<QuotedIdentifier>On</QuotedIdentifier>
</Build>
<Build Include="dbo\Views\Quarterly Orders.sql">
<AnsiNulls>On</AnsiNulls>
<QuotedIdentifier>On</QuotedIdentifier>
</Build>
<Build Include="dbo\Views\Invoices.sql">
<AnsiNulls>On</AnsiNulls>
<QuotedIdentifier>On</QuotedIdentifier>
</Build>
<Build Include="dbo\Views\Order Details Extended.sql">
<AnsiNulls>On</AnsiNulls>
<QuotedIdentifier>On</QuotedIdentifier>
</Build>
<Build Include="dbo\Views\Order Subtotals.sql">
<AnsiNulls>On</AnsiNulls>
<QuotedIdentifier>On</QuotedIdentifier>
</Build>
<Build Include="dbo\Views\Product Sales for 1997.sql">
<AnsiNulls>On</AnsiNulls>
<QuotedIdentifier>On</QuotedIdentifier>
</Build>
<Build Include="dbo\Views\Category Sales for 1997.sql">
<AnsiNulls>On</AnsiNulls>
<QuotedIdentifier>On</QuotedIdentifier>
</Build>
<Build Include="dbo\Views\Sales by Category.sql">
<AnsiNulls>On</AnsiNulls>
<QuotedIdentifier>On</QuotedIdentifier>
</Build>
<Build Include="dbo\Views\Sales Totals by Amount.sql">
<AnsiNulls>On</AnsiNulls>
<QuotedIdentifier>On</QuotedIdentifier>
</Build>
<Build Include="dbo\Views\Summary of Sales by Quarter.sql">
<AnsiNulls>On</AnsiNulls>
<QuotedIdentifier>On</QuotedIdentifier>
</Build>
<Build Include="dbo\Views\Summary of Sales by Year.sql">
<AnsiNulls>On</AnsiNulls>
<QuotedIdentifier>On</QuotedIdentifier>
</Build>
<Build Include="dbo\Stored Procedures\Ten Most Expensive Products.sql">
<AnsiNulls>On</AnsiNulls>
<QuotedIdentifier>On</QuotedIdentifier>
</Build>
<Build Include="dbo\Stored Procedures\Employee Sales by Country.sql">
<AnsiNulls>On</AnsiNulls>
<QuotedIdentifier>On</QuotedIdentifier>
</Build>
<Build Include="dbo\Stored Procedures\Sales by Year.sql">
<AnsiNulls>On</AnsiNulls>
<QuotedIdentifier>On</QuotedIdentifier>
</Build>
<Build Include="dbo\Stored Procedures\CustOrdersDetail.sql">
<AnsiNulls>On</AnsiNulls>
<QuotedIdentifier>On</QuotedIdentifier>
</Build>
<Build Include="dbo\Stored Procedures\CustOrdersOrders.sql">
<AnsiNulls>On</AnsiNulls>
<QuotedIdentifier>On</QuotedIdentifier>
</Build>
<Build Include="dbo\Stored Procedures\CustOrderHist.sql">
<AnsiNulls>On</AnsiNulls>
<QuotedIdentifier>On</QuotedIdentifier>
</Build>
<Build Include="dbo\Stored Procedures\SalesByCategory.sql">
<AnsiNulls>On</AnsiNulls>
<QuotedIdentifier>On</QuotedIdentifier>
</Build>
<Build Include="Security\Schema\SSDT.sql" />
</ItemGroup>
<ItemGroup>
<None Include="PublishProfiles\DEV.publish.xml" />
</ItemGroup>
</Project>
16 changes: 16 additions & 0 deletions samples/databases/Northwinds/Northwinds/PublishProfiles/DEV.publish.xml
View file
Original file line number Diff line number Diff line change
@@ -0,0 +1,16 @@
<?xml version="1.0" encoding="utf-8"?>
<Project ToolsVersion="Current" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
<PropertyGroup>
<IncludeCompositeObjects>True</IncludeCompositeObjects>
<TargetDatabaseName>Northwinds</TargetDatabaseName>
<DeployScriptFileName>Northwinds.sql</DeployScriptFileName>
<TargetConnectionString>Data Source=ssdtdemo.database.windows.net;Persist Security Info=False;User ID=nathan;Pooling=False;MultipleActiveResultSets=False;Connect Timeout=60;Encrypt=False;TrustServerCertificate=False</TargetConnectionString>
<BlockOnPossibleDataLoss>False</BlockOnPossibleDataLoss>
<DatabaseEdition>Basic</DatabaseEdition>
<DatabaseServiceObjective>Basic</DatabaseServiceObjective>
<DatabaseMaximumSize>1</DatabaseMaximumSize>
<IgnoreColumnOrder>True</IgnoreColumnOrder>
<DropObjectsNotInSource>True</DropObjectsNotInSource>
<ProfileVersionNumber>1</ProfileVersionNumber>
</PropertyGroup>
</Project>
2 changes: 2 additions & 0 deletions samples/databases/Northwinds/Northwinds/Security/Schema/SSDT.sql
View file
Original file line number Diff line number Diff line change
@@ -0,0 +1,2 @@
CREATE SCHEMA [SSDT]
AUTHORIZATION [DBO]
7 changes: 7 additions & 0 deletions samples/databases/Northwinds/Northwinds/dbo/Stored Procedures/CustOrderHist.sql
View file
Original file line number Diff line number Diff line change
@@ -0,0 +1,7 @@
CREATE PROCEDURE CustOrderHist @CustomerID nchar(5)
AS
SELECT ProductName, Total=SUM(Quantity)
FROM Products P, [Order Details] OD, Orders O, Customers C
WHERE C.CustomerID = @CustomerID
AND C.CustomerID = O.CustomerID AND O.OrderID = OD.OrderID AND OD.ProductID = P.ProductID
GROUP BY ProductName
10 changes: 10 additions & 0 deletions samples/databases/Northwinds/Northwinds/dbo/Stored Procedures/CustOrdersDetail.sql
View file
Original file line number Diff line number Diff line change
@@ -0,0 +1,10 @@

CREATE PROCEDURE CustOrdersDetail @OrderID int
AS
SELECT ProductName,
UnitPrice=ROUND(Od.UnitPrice, 2),
Quantity,
Discount=CONVERT(int, Discount * 100),
ExtendedPrice=ROUND(CONVERT(money, Quantity * (1 - Discount) * Od.UnitPrice), 2)
FROM Products P, [Order Details] Od
WHERE Od.ProductID = P.ProductID and Od.OrderID = @OrderID
10 changes: 10 additions & 0 deletions samples/databases/Northwinds/Northwinds/dbo/Stored Procedures/CustOrdersOrders.sql
View file
Original file line number Diff line number Diff line change
@@ -0,0 +1,10 @@

CREATE PROCEDURE CustOrdersOrders @CustomerID nchar(5)
AS
SELECT OrderID,
OrderDate,
RequiredDate,
ShippedDate
FROM Orders
WHERE CustomerID = @CustomerID
ORDER BY OrderID
Loading