Restrict varchar() column to specific values?

by

Have you already looked at adding a check constraint on that column which would restrict values? Something like: 

CREATE TABLE SomeTable
(
   Id int NOT NULL,
   Frequency varchar(200),
   CONSTRAINT chk_Frequency CHECK (Frequency IN ('Daily', 'Weekly', 'Monthly', 'Yearly'))
)

More Related Contents:

  1. sql server 2008 management studio not checking the syntax of my query
  2. SQL Server 2008: how do I grant privileges to a username?
  3. sql runs fast in ssms slow in asp.net
  4. Converting Select results into Insert script – SQL Server
  5. Efficiently convert rows to columns in sql server
  6. How can I get column names from a table in SQL Server?
  7. How can I select the first day of a month in SQL?
  8. Select statement to find duplicates on certain fields
  9. Using a Variable in OPENROWSET Query
  10. How to find current transaction level?
  11. Check for file exists or not in sql server?
  12. How to cast variables in T-SQL for bulk insert?
  13. How to create a PivotTable in Transact/SQL?
  14. Group DateTime into 5,15,30 and 60 minute intervals
  15. concatenate two database columns into one resultset column
  16. Why is a UDF so much slower than a subquery?
  17. Is there a SELECT … INTO OUTFILE equivalent in SQL Server Management Studio?
  18. Query runs slow with date expression, but fast with string literal
  19. T-SQL and the WHERE LIKE %Parameter% clause
  20. Custom aggregate function (concat) in SQL Server
  21. Which SQL query is faster? Filter on Join criteria or Where clause?
  22. UPDATE and REPLACE part of a string
  23. Improve SQL Server query performance on large tables
  24. Average of multiple columns
  25. Show all rows that have certain columns duplicated
  26. How to write a WHERE Clause to find all records in a specific month?
  27. How to make a view column NOT NULL
  28. Editing Record issues in Access / SQL (Write Conflict)
  29. Flattening of a 1 row table into a key-value pair table
  30. SQL Server equivalent of WM_CONCAT function [duplicate]

Leave a Comment