I have a simple table with 5 fields.
I select it and I press right button on it and select GENERATE SQL - INSERT STATEMENT - TO EDITOR and TOAD SS generate an insert statement in editor.
See screenshot for detail :
I see the statement generated. TOAD tell me that there is a problem- line 1, col 1: Incorrect syntax near '' - but I don't understand why ?
I execute, via F5 or F9 the insert statement and all is executed correctly.
I attach a new screenshot after execute it :
Have you some idea about this strange issue ?
This is the metadata of the table :
CREATE TABLE [dbo].[CAUSALI_RAPPORTINI] (
[CODICE] int IDENTITY(1, 1) NOT NULL,
[DESCR] varchar(40) NOT NULL,
[SYNCFIELD] timestamp NOT NULL,
[ULTMOD] datetime NOT NULL,
[UTENTE] varchar(40) NOT NULL)
ON [PRIMARY]
WITH (DATA_COMPRESSION = NONE);
GO
ALTER TABLE [dbo].[CAUSALI_RAPPORTINI] SET (LOCK_ESCALATION = TABLE);
I stay tune for your answer.
Best regards,
Sergio