CREATE TABLE dbo.Test (

jStart datetime NOT NULL CONSTRAINT DF_Test_jStart DEFAULT (getdate()),

j AS (convert(int,jStart,112)) ,

iSeq smallint NOT NULL , --no need for a default here as it's gonna change at every...

yup.

strSchoolDate=trim(Request.Form("school_date"))

it is not adding any lines of code... you're jut wrapping the inititalisation of variable with trim(request...)

It's the application's job.

HTH.

Function SetVars(SRvalue)

if SRvalue = "" Then

SetVars = null

else

SetVars = SRvalue

end if

End Function

decimal(4, 2) * decimal(4, 2) = decimal(8,4)

99.99 * 99.99 = 9998.0001

No you can't set the default scale on the server.

And what permission do your users have on the system??

This is something I didn't implement in my code generator but you might skip it for now :

if strSpecComments = "" Then

MyParam.Value = null

else

MyParam.Value = strSpecComments

end if

You could also wrap that into a function and call it... that'd save you a lot of code to write.

use this as the default instead and remove the cast in the constraint

dateadd(d, 0, datediff(d, 0, getdate()))

Also you can convert jstart to smalldatetime

if the value is "", then a null should be entered in the db, trim will do just fine.

the only missing thing is that you don't account for nulls, and that you don't trim the values from the request.querystring (small bug that can bit you).

Looks like he's waiting for me to hit the 5K mark to start posting again .