Home Forums SQL Server 7,2000 General pseudocode........ RE: pseudocode........
EdH334
SSCrazy
Points: 2857
More actions
July 14, 2003 at 3:00 am
#465264
Try:
if (dob IS NULL)
BEGIN
insert
from [tablename]
END
else
insert * from [tablename]
Although in this case you don't need the BEGIN and END and there is only a single line of code in the IF statement.
-Ed