Geek Answers Handbook

Can I execute multiple statements in SQL Server Compact 4?

I am trying to get multiple attachments to work in one script using SQL Compact 4.0 Toolbox and no luck. I keep getting syntax error.

I even tried to add GO; between these statements so.

INSERT INTO ... ; GO; INSERT INTO ... ;

no luck .. so lucky me? Should I just perform each statement one at a time?

+8
sql-server-ce-toolbox
source share
1 answer

Update to the latest version (2.3). An error occurred while executing several statements, which was fixed in the latest version. Separate each expression with GO on a separate line, followed by a comma 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
+6
source share

More articles:


All Articles