SQL Complete can't script an insert from a result grid if there's a timestamp column

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
Thenrich
Posts: 105
Joined: Sun 21 Dec 2014 19:47

SQL Complete can't script an insert from a result grid if there's a timestamp column

Post by Thenrich » Mon 08 Jan 2018 20:26

I have a select statement and when I highlight a row in the result grid and select Script As Insert, nothing happens. I found out if I remove the column of type timestamp, it works. If I am using *, I have to expand the columns and then remove that column.
Seems like a bug to me.

alexa

Re: SQL Complete can't script an insert from a result grid if there's a timestamp column

Post by alexa » Tue 09 Jan 2018 17:58

We will investigate this issue and will answer you as soon as possible.

Thenrich
Posts: 105
Joined: Sun 21 Dec 2014 19:47

Re: SQL Complete can't script an insert from a result grid if there's a timestamp column

Post by Thenrich » Mon 05 Feb 2018 19:18

The new update didn't fix this issue! If you can't script a timestamp column, either ignore it or show a warning message. Some users might think the feature is broken.

Post Reply