May 31, 2002 #1 kshea Technical User May 31, 2002 60 CA Hi everyone: I know how to set a default value in table design view. But is it possible to set a default using T-SQL? Thanks.
Hi everyone: I know how to set a default value in table design view. But is it possible to set a default using T-SQL? Thanks.
May 31, 2002 #2 Bastien Programmer May 29, 2000 1,683 CA sql= "insert into mytable (fname,lname,status) values('& request.form("fname" &"','" & request.form("lname" & "',0)" where status is set to 0 as default request.form is ASP type VBscript code hth Bastien There are many ways to skin this cat, but it still tastes like chicken Upvote 0 Downvote
sql= "insert into mytable (fname,lname,status) values('& request.form("fname" &"','" & request.form("lname" & "',0)" where status is set to 0 as default request.form is ASP type VBscript code hth Bastien There are many ways to skin this cat, but it still tastes like chicken