Mega Code Archive
Check for data length
<![CDATA[
3> CREATE TABLE T (
4> int1 int IDENTITY PRIMARY KEY,
5> vch1 varchar(5)
6> CHECK (LEN(vch1) > 0)
7> NOT NULL,
8> vch2 varchar(5)
9> CONSTRAINT CK_LEN_TOO_SHORT
10> CHECK (LEN(vch2) > 0)
11> NOT NULL
12> )
13> GO
1>
2>
3> drop table t;
4> GO
]]>