且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

我可以在SQL Server Compact 4中执行多个语句吗?

更新时间:2022-06-27 02:52:34

更新到最新发行版本(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