Declare @Phone nvarchar(30); Declare @Fax nvarchar(30); select @Phone = phone , @Fax = fax from customer where customerID = 1;