Check Constraint for Null and …
10-Nov-1010 Leave a comment
ALTER TABLE [Production].[TimeSheet] WITH CHECK ADD CONSTRAINT [CK_TimeSheet_TimeEndLaterThanStart] CHECK (([TimeEnd] IS NULL) OR [TimeEnd]>=[TimeStart])
Categories
Recent Posts
Archives
- October 2019 (1)
- June 2019 (1)
- March 2019 (1)
- January 2019 (1)
- November 2018 (1)
- October 2018 (2)
- March 2016 (2)
- December 2015 (1)
- October 2015 (1)
- September 2015 (1)
- April 2015 (1)
- February 2015 (2)
- December 2014 (2)
- September 2014 (2)
- August 2014 (1)
- July 2014 (5)
- June 2014 (5)
- May 2014 (7)
- April 2014 (4)
- February 2014 (1)
- January 2014 (1)
- December 2013 (3)
- November 2013 (8)
- October 2013 (7)
- September 2013 (2)
- August 2013 (9)
- July 2013 (2)
- June 2013 (6)
- May 2013 (10)
- April 2013 (1)
- March 2013 (4)
- February 2013 (2)
- January 2013 (5)
- December 2012 (7)
- November 2012 (2)
- October 2012 (7)
- September 2012 (3)
- August 2012 (5)
- July 2012 (12)
- June 2012 (11)
- April 2012 (4)
- March 2012 (4)
- February 2012 (16)
- January 2012 (7)
- December 2011 (9)
- November 2011 (8)
- October 2011 (5)
- September 2011 (14)
- August 2011 (10)
- July 2011 (13)
- June 2011 (3)
- May 2011 (8)
- April 2011 (9)
- March 2011 (8)
- February 2011 (12)
- January 2011 (6)
- December 2010 (3)
- November 2010 (14)
- October 2010 (6)
- August 2010 (3)
- July 2010 (18)
- June 2010 (2)
- April 2010 (3)
- March 2010 (3)
- February 2010 (10)
- January 2010 (7)
- December 2009 (3)
- November 2009 (9)
- October 2009 (1)
- September 2009 (11)
- August 2009 (14)
- July 2009 (13)
- June 2009 (7)
Stephen Shakespeare 