我使用 SQLAzureMW v3.8.8, 但我在生成的脚本中发现很多错误。 问题是我不知道每个错误在哪一行产生。
Error #: 105 -- Unclosed quotation mark after the character string CREATE PROCEDURE [dbo].[spAdminParametrosGet]
# 错误: 156 - 关键字ELSE 附近的语法不正确 。
Error #: 40512 -- Deprecated feature NOLOCK or READUNCOMMITTED in UPDATE or DELETE is not supported in this version of SQL Server.
接近于不正确的语法
TSQL 脚本生成 sql 存储程序作为字符串, 并使用动态 SQL 创建。 有些存储程序在其中含有注释 。
可能是因为或暗示要迅速将数据库迁移到阿祖尔?
您想要从 SQL 服务器迁移到 SQL Azure 的一些 SP 和其他语句非常可能不兼容。 以下是支持和不支持 TSQL 功能列表 :
http://msdn.microsoft.com/en-us/library/windowsazure/ee336250.aspx
您也没有提及您的源 SQL 服务器是什么? 因为并非所有 SQL 服务器都由 SAMQ (3. 8 或 4. 01) 支持全部功能, 所以不是所有 SQL 服务器都由 SAMQ (3. 8 或 4. 01) 支持 。
另请将您的 TSQL 语句与以下无支持列表匹配,并检查以下所列任何语句是否为您的 TSQL 语句的一部分:
http://msdn.microsoft.com/en-us/library/windowsazure/ee336253.aspx
I m part of a development team that works on many CMS based projects, using systems like Joomla and Drupal. In our development process, all of our code changes are managed inside of Git. At the end ...
I am in the process of migrating an existing Access database to a SQL database with a web front-end. I have successfully copied the database to SQL using the SQL Server Migration tool and am working ...
I m building a Rails application using MongoDB as the back-end and MongoMapper as the ORM tool. Suppose in version 1, I define the following model: class SomeModel include MongoMapper::Document ...
I m considering switching from MFC to WPF. My first concern is that there are too many users who don t have .NET with WPF installed yet. Can anybody point to a source containing the WPF penetration ...
I m fairly new to Ruby on Rails here. I have 2 migrate files that were provided. The first one, prefixed with 001, creates a table and some columns for that table. The next migrate file, prefixed ...
I have a svn repo with various apps as subdirectory of a single svn repo. That worked because I could have checked out a partial, repo. As I cant do that with git obviously I need multiple repos. I ...
我是铁路的开端人,试图了解铁路移民是如何运作的。
I am reviewing currently a medium size code base (around 30K LOC) which uses a huge Applet and interfaces with other systems. It s a tool to create custom labels, so we need drag-n-drop and other ...
