一次执行多条sql语句

// 一次执行多条sql语句
            string strconn = @"Data Source=.\sqlexpress;Initial Catalog=info;Integrated Security=True";
            SqlConnection cnn = new SqlConnection(strconn);
            string sql = @"declare @bname nvarchar(50);
            select @bname = book_name from Book where book_id = '2';
            select * from Book where book_name like '%'+@bname+'%';";
            SqlCommand cmd = new SqlCommand(sql, cnn);
            cnn.Open();
            SqlDataReader dr = cmd.ExecuteReader();
            dr.Read();
            dr.GetString(4);
            dr.Close();
            cnn.Close();