create proc sp_get_hostip(@ip varchar(15) output) AS declare @cmd varchar(200);create table #ipTemp(ipt