我可以在SQL Server Compact 4中执行多个语句吗? [英] Can I execute multiple statements in SQL Server Compact 4?

问题描述

我试图使用SQL Compact 4.0工具箱在单个脚本中工作多个插入，但没有任何运气.我不断收到解析错误.

I'm trying to get multiple inserts to work in a single script using the SQL Compact 4.0 Toolbox and not having any luck. I keep getting a parsing error.

我什至尝试添加GO；像这样在每个语句之间.

I've even tried adding GO; between each statement like so..

INSERT INTO ... ;

GO;

INSERT INTO ... ;

没有运气..那我走运了吗?我是否必须一次执行每个语句?

with no luck.. so am I out of luck? Do I have to just execute each statement one at a time?

推荐答案

更新到最新发行版本(2.3).在执行多个语句时存在一个错误，该错误已在最新版本中修复. 用GO将每个语句分隔在单独的行上，之后不使用分号... 类似于该工具创建的INSERT语句:

Update to the latest release version (2.3). There was a bug with multiple statement execution, that has been fixed in the latest release version. Seperate each statement with GO on a separate line, no semicolon after... Like the INSERT statements created by the tool:

INSERT INTO [Shippers] ([Shipper ID],[Company Name]) VALUES (1,N'Speedy Express');
GO
INSERT INTO [Shippers] ([Shipper ID],[Company Name]) VALUES (2,N'United Package');
GO
INSERT INTO [Shippers] ([Shipper ID],[Company Name]) VALUES (3,N'Federal Shipping');
GO

这篇关于我可以在SQL Server Compact 4中执行多个语句吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！