SEO

#1 (**permalink**) 02-29-2008, 02:58 AM

We ran into a problem loading access where tables where if we did not
select the property allow zero length we got an error message when
loading data with some empty values.

We are now ramping up SQL server and the question came up will SQL
server have the same problem with empty data values.

Is there an SQL server equivalent to allow zero length?

#2 (**permalink**) 02-29-2008, 02:58 AM

SQL-Server will always allow zero length values, unless you explicitely
add a constraint to disallow this.

So, by default, zero length values are allowed. If you do not want that,
you could run

ALTER TABLE mytable
ADD CONSTRAINT constraintname
CHECK (mycol <> '')

for each relevant column.

Hope this helps,
Gert-Jan

William Kossack wrote:
>
> We ran into a problem loading access where tables where if we did not
> select the property allow zero length we got an error message when
> loading data with some empty values.
>
> We are now ramping up SQL server and the question came up will SQL
> server have the same problem with empty data values.
>
> Is there an SQL server equivalent to allow zero length?

--
(Please reply only to the newsgroup)

#3 (**permalink**) 02-29-2008, 02:58 AM

thanks

Gert-Jan Strik wrote:

> SQL-Server will always allow zero length values, unless you explicitely
> add a constraint to disallow this.
>
> So, by default, zero length values are allowed. If you do not want that,
> you could run
>
> ALTER TABLE mytable
> ADD CONSTRAINT constraintname
> CHECK (mycol <> '')
>
> for each relevant column.
>
> Hope this helps,
> Gert-Jan
>
> William Kossack wrote:
> >
> > We ran into a problem loading access where tables where if we did not
> > select the property allow zero length we got an error message when
> > loading data with some empty values.
> >
> > We are now ramping up SQL server and the question came up will SQL
> > server have the same problem with empty data values.
> >
> > Is there an SQL server equivalent to allow zero length?
>
> --
> (Please reply only to the newsgroup)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Allow zero length