Free for PREMIUM members
CREATE TABLE #test
DateCol DATE CONSTRAINT DF_Test_DateCol DEFAULT ( GETDATE() )
Open in new window
CREATE TABLE #tmp (id int, dt date DEFAULT CAST(GETDATE() as date))
INSERT INTO #tmp (id) values (1), (2), (3)
SELECT * FROM #tmp
Gartner Research VP, Neil McDonald & AlgoSec CTO, Prof. Avishai Wool, discuss the business-driven approach to automated security policy management, its benefits and how to align security policy management with business processes to address today's security challenges.
GETDATE() is actually Sybase syntax carried over to SQL and is not ansi-compliant, so it may be being phased out by MS.
Author Closing Comment
Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.
If you are experiencing a similar issue, please ask a related question
Join the community of 500,000 technology professionals and ask your questions.
Join & Ask a Question
Join our community for more solutions or to ask questions.
For immediate help use Live now!