In SQL Server 2012, set the time default value to "Current Time"

Recently, you need to set the default value for DateTime to the current time in SQL Server 2012.

Set through a visual window instead of writing the GETDATE () function in an SQL statement, or writing ' 2022-2-2 22:22:22 ' in an SQL statement.

At first, there are articles written on the Internet, but more is written in the SQL statement, then the format of the default is some problem, has failed.

Correct illustrations: (GETDATE ())

In fact, it is a visualization, in the SQL statement spelling getdate () can be OK, in the Visual window is OK.

It is so simple, but then the brain is disabled, must add single quotation marks what a mess, the ignition, lesson bar ~

In SQL Server 2012, set the time default value to "Current Time"