CODEWITHSUNDEEP
sql-serverssms
OrionSoftTechnologiesSydney
OrionSoftTechnologiesSydney

Reputation: 650

SSMS - Add a column with data type datetime and default value for binding to current date and time

Is it possible to add a column to an existing table with data type "datetime" and then set the default value for binding to current date and time?

I am using SQL Server 2008.

Upvotes: 0

Views: 952

Answers (1)

nicomp
nicomp

Reputation: 4647

See attached for an example. on how to do this

See attached for an example. on how to do this

Upvotes: 2

Related Questions