Skip to content
← SQL Complete

How can we improve SQL Complete?

SQL Complete: Features

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Choose Default Date For Insert/Update Statements

When auto-expanding an insert or update statement by pressing the tab key, the column list provides default values for the columns. With DateTime and DateTime2 in particular, it would be helpful to configure if you want to use the UTC datetime or the current timezone. Our company exclusively stores datetimes in UTC, so to have this default this way would be extremely helpful!

CREATE TABLE #tmp (ID INT, CreatedDateUtc DATETIME2, Name NVARCHAR(50))

INSERT INTO #tmp (ID, CreatedDateUtc, Name)
VALUES (0, SYSDATETIME(), N''); -- allow this to populate as SYSUTCDATETIME() or GETUTCDATE(), depending on DATETIME2 vs DATETIME

1 vote
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Matt MacDonald shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • AdminDevart (_, Devart) commented  ·   ·  Report

    Hi Matt,

    You are absolutely right. My apologies for the confusion. Please ignore our previous reply.

    Please rest assured that we have passed this feature request to our Product team for a review.

    A hight number of votes here would speed up the review and implementation process, so let's hope to get more votes.

    Once there is an update regarding implementation and release, you will be informed.

    Best,

    Devart Support Team

  • Matt MacDonald commented  ·   ·  Report

    Forgive me if I'm missing it, but I don't see a "Data Generation" menu. Please let me know where to find it. Thank you!

  • AdminDevart (_, Devart) commented  ·   ·  Report

    Hi,

    Thanks for your patience!

    Please be informed that the date is displayed as it is stored on the server.

    For additional display options, check the settings under Data Generation > Formatting.

    Best,

    Devart Support Team