The transactions will never be committed, the locks those updates take will be held until the connection is closed. When the connection is closed, because there has been no commit statement issued, SQL will roll back all changes.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability