语句句式转换
有些语句要求附加操作使用在MSSQLServer 2008更新的版本。
- Dbcc DbReindex
- Drop Index索引
- Three-part列引用
- Four-part
列引用
比如:
Microsoft SQL Server 2000:
UPDATE dbo.ispirer.shop
SET good = “Milk”
WHERE dbo.ispirer.shop.good_id = 18
Microsoft SQL Server 2008:
WITH s AS (SELECT * FROM dbo.ispirer.shop )
UPDATE s
SET good = “Milk”
WHERE s. good_id = 18
- 升级和Nolock在From子句
- 表提示没有With
- 索引选项没有支架
- 加入旧版是
比如:
Microsoft SQL Server 2000:
SELECT shop_name FROM shop, customer
WHERE shop.good_id*=customer.good_id
AND customer.price=123 AND shop.good= “Milk”
Microsoft SQL Server 2008:
SELECT shop_name FROM shop LEFT OUTER JOIN customer ON
shop.good_id=customer.good_id AND customer.price=123
WHERE shop.good= “Milk”
- 使用别名在ORDER BY
比如:
Microsoft SQL Server 2000:
SELECT DISTINCT CONVERT(VARCHAR, good_date,112)
AS good_date FROM shop ORDER BY shop.good_date
Microsoft SQL Server 2008:
SELECT DISTINCT CONVERT(VARCHAR, good_date,112)
AS good_date FROM shop ORDER BY good_date
Microsoft SQL Server 2000:
SELECT CONVERT(VARCHAR, good_date,112)
AS good_date, good_date FROM shop
ORDER BY good_date
Microsoft SQL Server 2008:
SELECT CONVERT(VARCHAR, good_date,112)
AS good_date, good_date FROM shop
ORDER BY CONVERT(VARCHAR, good_date,112)
Microsoft SQL Server 2000:
SELECT good_date, CONVERT(VARCHAR, good_date,112)
AS good_date FROM shop ORDER BY good_date
Microsoft SQL Server 2008:
SELECT good_date, CONVERT(VARCHAR, good_date,112)
AS good_date FROM shop ORDER BY shop.good_date
如果您需要了解升级有些句式附加信息,请访问一章对于MSSQL Server升级句式在我们的Wiki页:
http://wiki.ispirer.com/sqlways/sql-server/upgrade/statementssyntax
除了服务端域逻辑,Ispirer MnMTK转换SQL查询在前端应用和脚本。
如果您订购Ispirer MnMTK迁移软件演示,请您点击现场演示请求。如果您需要寻找价格政策,请您点击 报价请求。