C#

<br />
System.Net.WebProxy objProxy = new System.Net.WebProxy("http://1.2.3.5:8080/", true);<br />
YourService.Proxy = objProxy;<br />

<br />
YourService.Proxy = null; <br />

using (SqlConnection sc = new SqlConnection())
        {
            StringBuilder sql = new StringBuilder(); // or simply use string instead
            sql.Append("exec sp_YourProc");
            string connStr = "...";
            sc.ConnectionString = connStr;
            sc.Open();
            using (SqlCommand sco = new SqlCommand())
            {
                try
                {
                    sco.CommandType = CommandType.Text;
                    sco.CommandText = sql.ToString();
                    sco.Connection = sc;
                    using (SqlDataReader sr = sco.ExecuteReader())
                    {
                        // Do something with the incoming data;
                    }
                }
                catch (SqlException exc)
                {
                    // ... Deal with exceptions
                }
            }

SqlParameter outParam = new SqlParameter("@myOutParam",SqlDbType.Int);<br />
outParam.Direction = ParameterDirection.Output;<br />
myCmd.Parameters.Add(outParam);