Very Computer

by **ramirezmend** » Wed, 30 May 2001 19:48:11

why does the insert statement don't work???
(the duration row is a int type.)

insert into log(duration)values('90890p')

BEGIN
print 'error'
END

by **Bob Pfeif** » Wed, 30 May 2001 20:11:10

If the duration column is an int datatype, you can't insert a value that has
an alphabetical character in it.

by **Mark Allis** » Wed, 30 May 2001 22:44:27

You are trying to insert a character into an integer field. Change
your datatype in the table of remove the character.

Mark Allison.

> why does the insert statement don't work???
> (the duration row is a int type.)

> insert into log(duration)values('90890p')

> BEGIN
> print 'error'
> END

exception handling sqlserver (insert statement)