search

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.5k stars 883 forks source link

Build error SQL70001: This statement is not recognized in this context. #25712

Open hongxingzhao1998 opened 1 week ago

hongxingzhao1998 commented 1 week ago

I am using SQL database project extension in Visual Studio code, when tried to build the database project, it gave me this error

Build error SQL70001: This statement is not recognized in this context.

=================================================== Visual Studio Code Output: [ Build ]

"C:\Program Files\dotnet\dotnet.exe" build "c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj" /p:NetCoreBuild=true /p:SystemDacpacsLocation="c:\Users\bt-HZhao\.vscode\extensions\ms-mssql.sql-database-projects-vscode-1.4.1\BuildDirectory" stdout: MSBuild version 17.3.4+a400405ba for .NET stdout: stdout: Determining projects to restore... stdout: stdout: All projects are up-to-date for restore. stdout: stdout: Creating a model to represent the project... stdout: stdout: Loading project references... stdout: stdout: Loading project files... stdout: stdout: Building the project model and resolving object interdependencies... stdout: stdout: Validating the project model... stdout: stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\GetSources.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\GetSources.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\AddLoggingADF.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\AddLoggingADF.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\SqlToOracleDate.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\SqlToOracleDate.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\OracleToSqlDate.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\OracleToSqlDate.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\ConvertDateTimeToString.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\ConvertDateTimeToString.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\AddTableStatus.sql(1,1,1,1): Build warning SQL71558: The object reference [Management].[AddTableStatus].[@META_LOAD_DATETIME] differs only by case from the object definition [Management].[AddTableStatus].[@meta_load_datetime]. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: stdout: stdout: Build FAILED. stdout: stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\AddTableStatus.sql(1,1,1,1): Build warning SQL71558: The object reference [Management].[AddTableStatus].[@META_LOAD_DATETIME] differs only by case from the object definition [Management].[AddTableStatus].[@meta_load_datetime]. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\GetSources.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\GetSources.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\AddLoggingADF.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\AddLoggingADF.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\SqlToOracleDate.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\SqlToOracleDate.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\OracleToSqlDate.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\OracleToSqlDate.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\ConvertDateTimeToString.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\ConvertDateTimeToString.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: 1 Warning(s) stdout: 10 Error(s) stdout: stdout: stdout: Time Elapsed 00:00:03.93 stdout:

"C:\Program Files\dotnet\dotnet.exe" build "c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj" /p:NetCoreBuild=true /p:SystemDacpacsLocation="c:\Users\bt-HZhao\.vscode\extensions\ms-mssql.sql-database-projects-vscode-1.4.1\BuildDirectory" … exited with code: 1 "C:\Program Files\dotnet\dotnet.exe" build "c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj" /p:NetCoreBuild=true /p:SystemDacpacsLocation="c:\Users\bt-HZhao\.vscode\extensions\ms-mssql.sql-database-projects-vscode-1.4.1\BuildDirectory" … errored out: Process exited with code 1 [ Build ] "C:\Program Files\dotnet\dotnet.exe" build "c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj" /p:NetCoreBuild=true /p:SystemDacpacsLocation="c:\Users\bt-HZhao\.vscode\extensions\ms-mssql.sql-database-projects-vscode-1.4.1\BuildDirectory" stdout: MSBuild version 17.3.4+a400405ba for .NET stdout: stdout: Determining projects to restore... stdout: stdout: All projects are up-to-date for restore. stdout: stdout: Creating a model to represent the project... stdout: stdout: Loading project references... stdout: stdout: Loading project files... stdout: stdout: Building the project model and resolving object interdependencies... stdout: stdout: Validating the project model... stdout: stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\GetSources.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\GetSources.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\AddLoggingADF.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\AddLoggingADF.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\SqlToOracleDate.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\SqlToOracleDate.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\OracleToSqlDate.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\OracleToSqlDate.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\ConvertDateTimeToString.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\ConvertDateTimeToString.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\AddTableStatus.sql(1,1,1,1): Build warning SQL71558: The object reference [Management].[AddTableStatus].[@META_LOAD_DATETIME] differs only by case from the object definition [Management].[AddTableStatus].[@meta_load_datetime]. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: stdout: stdout: Build FAILED. stdout: stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\AddTableStatus.sql(1,1,1,1): Build warning SQL71558: The object reference [Management].[AddTableStatus].[@META_LOAD_DATETIME] differs only by case from the object definition [Management].[AddTableStatus].[@meta_load_datetime]. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\GetSources.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\GetSources.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\AddLoggingADF.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Stored Procedures\AddLoggingADF.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\SqlToOracleDate.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\SqlToOracleDate.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\OracleToSqlDate.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\OracleToSqlDate.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\ConvertDateTimeToString.sql(1,1,1,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\Functions\ConvertDateTimeToString.sql(3,1,3,1): Build error SQL70001: This statement is not recognized in this context. [c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj] stdout: 1 Warning(s) stdout: 10 Error(s) stdout: stdout: Time Elapsed 00:00:04.71 stdout: "C:\Program Files\dotnet\dotnet.exe" build "c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj" /p:NetCoreBuild=true /p:SystemDacpacsLocation="c:\Users\bt-HZhao\.vscode\extensions\ms-mssql.sql-database-projects-vscode-1.4.1\BuildDirectory" … exited with code: 1 "C:\Program Files\dotnet\dotnet.exe" build "c:\Users\bt-HZhao\Repo\SterigenicsDatabase.DB\SterigenicsDatawarehouse\SterigenicsDatawarehouse.sqlproj" /p:NetCoreBuild=true /p:SystemDacpacsLocation="c:\Users\bt-HZhao\.vscode\extensions\ms-mssql.sql-database-projects-vscode-1.4.1\BuildDirectory" … errored out: Process exited with code 1