0

Check constraint sqlsever

How am I to create a check constraint on a table to make sure the date on that column is not less than the current date. Please hope the question is understood.

27th Aug 2020, 12:38 AM
esther iyege
esther iyege - avatar
2 Respuestas
+ 1
Examples on these pages may get you an idea * Check constraints https://www.w3schools.com/SQL/sql_check.asp * Get current date & time https://www.w3schools.com/sql/func_sqlserver_getdate.asp
27th Aug 2020, 1:57 AM
Ipang
+ 1
Esther, How's it going? did you make it? I hope you did. Anyways, if you did, I recommend you to share the SQL code here. It might be useful for someone who seeks for similar solution in the future. Sharing is caring 👍
28th Aug 2020, 6:19 AM
Ipang