my $sql = "DECLARE \@log varchar(5) SET \@log=$tim Update dbo.tltime set logtime = \@log"; # ... here --^