CHECK CONSTRAINT on multiple columns

by

Yes, define the CHECK CONSTRAINT at the table level

CREATE TABLE foo (
   bar int NOT NULL, 
   fred varchar(50) NOT NULL,

   CONSTRAINT CK_foo_stuff CHECK (bar = 1 AND fred ='fish')
)

You are declaring it inline as a column constraint

...
fred varchar(50) NOT NULL CONSTRAINT CK_foo_fred CHECK (...)
...

Edit, easier to post than describe. Fixed your commas.

CREATE TABLE dbo.Test 
(   
  EffectiveStartDate  dateTime2(2)        NOT NULL,
  EffectiveEndDate    dateTime2(2)        NOT NULL,  --need comma
  CONSTRAINT CK_CmsSponsoredContents_EffectiveEndDate CHECK (EffectiveEndDate > EffectiveStartDate) --no comma
);

Of course, the question remains are you using a CHECK constraint where it should be an FK constraint…?

More Related Contents:

  1. Sql to select the rows and ignore the duplicate userid in SQL Server [closed]
  2. How to concatenate text from multiple rows into a single text string in SQL Server
  3. How to SELECT FROM stored procedure
  4. What’s the best practice for primary keys in tables? [closed]
  5. Avoid duplicates in INSERT INTO SELECT query in SQL Server
  6. How do you list the primary key of a SQL Server table?
  7. Calculating distance between two points (Latitude, Longitude)
  8. SQL Server check case-sensitivity?
  9. Concat groups in SQL Server [duplicate]
  10. Multiplication aggregate operator in SQL
  11. How to update Identity Column in SQL Server?
  12. SQL Server: Get table primary key using sql query [duplicate]
  13. How to determine the number of days in a month in SQL Server?
  14. Concatenate values based on ID
  15. Finding duplicate rows in SQL Server
  16. Why and when a LEFT JOIN with condition in WHERE clause is not equivalent to the same LEFT JOIN in ON? [duplicate]
  17. Detect consecutive dates ranges using SQL
  18. how to declare global variable in SQL Server..?
  19. Scope of temporary tables in SQL Server
  20. Convert text value in SQL Server from UTF8 to ISO 8859-1
  21. Split values over multiple rows [duplicate]
  22. How to do an inner join on row number in sql server
  23. SQL Server 2005 ROW_NUMBER() without ORDER BY
  24. Must declare the scalar variable
  25. Can an INNER JOIN offer better performance than EXISTS
  26. Getting Dates between a range of dates
  27. SQL Server 2008 paging methods?
  28. how to separate string into different columns?
  29. How to compare dates in SQL Server
  30. How do I expand comma separated values into separate rows using SQL Server 2005?

Leave a Comment