malisnet.com
Musheer Ali's Network
Musheer Ali's Network
Apr 5th
India won the cricket world cup 2011 and this is second time India titled as World Champions after 28 years. And this was probably last world cup of Sachin Tendulkar and his dream came true. The difference between India and other team in this world cup is Yuvraj Saingh. He played brilliantly and he is a match winner.
“Could not ask any thing better than this. This is the biggest moment in my life” – Sachin Tendulkar
“I wanted to win this world cup for Sachin Tendulkar” – Yuvraj Singh
“Sachin Carried the Burden of Indian Cricket on His Shoulder for last 21yrs.. Now Its Time We Carry Him on Our Shoulders” – Virat Kohli
| Player | Mat | Inns | NO | Runs | HS | Ave | BF | SR | 100 | 50 | 0 | 4s | 6s |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SR Tendulkar (India) | 9 | 9 | 0 | 482 | 120 | 53.55 | 524 | 91.98 | 2 | 2 | 0 | 52 | 8 |
| G Gambhir (India) | 9 | 9 | 0 | 393 | 97 | 43.66 | 462 | 85.06 | 0 | 4 | 0 | 37 | 0 |
| V Sehwag (India) | 8 | 8 | 0 | 380 | 175 | 47.50 | 310 | 122.58 | 1 | 1 | 1 | 49 | 7 |
| Yuvraj Singh (India) | 9 | 8 | 4 | 362 | 113 | 90.50 | 420 | 86.19 | 1 | 4 | 1 | 39 | 3 |
| V Kohli (India) | 9 | 9 | 1 | 282 | 100* | 35.25 | 343 | 82.21 | 1 | 1 | 0 | 24 | 2 |
| MS Dhoni (India) | 9 | 8 | 3 | 241 | 91* | 48.20 | 295 | 81.69 | 0 | 1 | 0 | 19 | 3 |
| Player | Mat | Overs | Mdns | Runs | Wkts | BBI | Ave | Econ | SR | 4 | 5 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Z Khan (India) | 9 | 81.3 | 4 | 394 | 21 | 3/20 | 18.76 | 4.83 | 23.2 | 0 | 0 |
| Yuvraj Singh (India) | 9 | 75.0 | 2 | 377 | 15 | 5/31 | 25.13 | 5.02 | 30.0 | 0 | 1 |
| MM Patel (India) | 8 | 65.5 | 1 | 353 | 11 | 4/48 | 32.09 | 5.36 | 35.9 | 1 | 0 |
| Harbhajan Singh (India) | 9 | 87.0 | 2 | 390 | 9 | 3/53 | 43.33 | 4.48 | 58.0 | 0 | 0 |
Pictures:
Apr 5th
Jan 5th
There is no specified query for pagination in sybase. But we can create our own method for pagination in sybase database.The following is an example for that..
————————
CREATE PROCEDURE sp_get_posts
@perpage smallint,
@pagenumber smallint
WITH RECOMPILE
AS
begin
– if we’re on the first page no need to go through the @postid push
IF @pagenumber = 1
Begin
SET ROWCOUNT @perpage
SELECT *
FROM entry_posts
ORDER BY post_id ASC
RETURN
END
– otherwise
DECLARE @min_id smallint,
@position INT
SELECT @position = @perpage * ( @pagenumber – 1 ) + 1
SET ROWCOUNT @position –setting the starting position
– What happens here is it will select through the rows
– and order the whole set.
– It will stop push postid into @min_postid until it hits
– ROWCOUNT and does this out of the ordered set (a work
– table).
SELECT @min_id = post_id
FROM entry_posts
ORDER BY post_id ASC
SET ROWCOUNT @perpage –setting the ending position
SELECT *
FROM entry_posts
WHERE post_id >= @min_id
ORDER BY post_id ASC
end
———————
This is not published behaviour and is not guaranteed by Sybase.
Dec 7th
England won the second Ashes Test by an innings and 71 runs to take a 1-0 lead in the five-match series.
This is very interesting match as like any other Ashes test match. Kevin Pietersen scored a match winning double century and first century since 2009. Kevin Pietersen recorded his personnel Test best of 227 beating his previous best of 226 against WI in 2007.
England continues their brilliant performance in recent times.
Graeme Swann completed a five-wicket haul and James Anderson took two wickets in two balls as the tourists’ took their first test victory on Australian soil since the 2002-03 tour.
Ricky Ponting isn’t sure whether the situation he’ll face over the next three Tests is the biggest challenge of his career.
And it all happened under the most perfect, sunny skies. If Australia were hoping for storms, their prayers were not answered. In truth, they never recovered from the hurricane that struck on the first morning when they were 3 for 2. And now, England need only one more victory to retain the Ashes.