Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.
Your profile
Tag cloud
book bug business intelligence database dates dmv functions gemini gotcha how to howto indexing interview madison performance performance tuning programming security sql sql friday sql server sql server 2000 sql server 2005 sql server 2008 sql server 2008 r2 sqlserver t-sql tip trick xml
Authors
- SQLDenis (166)
- onpnt (86)
- George Mastros (32)
- chrissie1 (8)
- naomi (7)
- emtucifor (6)
- Alex Ullrich (6)
- thirster42 (4)
- ramireddyindia (2)
- riverguy (1)
- tarwn (1)
- pmch22 (1)
- More...
Main Categories
Search
XML FeedsGoogle Ads
Tags: pitfall
Someone posted the following question
I need to add table called group with a column called code
How do I add a check constraint to the column so it will only allow the following alphabetic characters (D, M, O, P or T) followed by 2 numeric characters.
Someone posted the following answer
You cannot do this out of the box - MS SQL Server does support CHECK CONSTRAINTS - but for things like a maximum or minimum INT value, or a string length or such.
What you're looking for would be a CHECK based on a regular expressio...
Take a look at this code
LTD Social Sitings
Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.