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