>I get this error on the block below:
>
>Msg 2716, Level 16, State 1, Line 243
>Column, parameter, or variable #42: Cannot specify a column width on data type int.
>
>
>
>DECLARE @Count AS INTEGER(4)
>
>SET @Count = 0
>.
>.
>.
>SET @Count = @Count + 1
>
Integer is one of the types that you don't have to specify length. It is always 4 bytes
So instead:
DECLARE @Count AS INTEGER(4)
just do:
DECLARE @Count AS INTEGER
Other types that does not require such thing are:
smallint,
tinyint,
datetime,
smalldatetime,
text,
image
maybe I'm missing some of them right now, but I feel so sleepy :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.