Thursday, April 29, 2010
Monday, April 26, 2010
Thursday, April 22, 2010
SQL Server 2000 also supports temporary stored procedures that, like temporary tables, are dropped automatically when you disconnect. Temporary stored procedures are stored in tempdb and are useful when connected to earlier versions of SQL Server. Temporary stored procedures can be used when an application builds dynamic Transact-SQL statements that are executed several times. Rather than have the Transact-SQL statements recompiled each time, you can create a temporary stored procedure that is compiled on the first execution, and then execute the precompiled plan multiple times. Heavy use of temporary stored procedures, however, can lead to contention on the system tables in tempdb.
Two features of SQL Server 2000 and SQL Server 7.0 eliminate the need for using temporary stored procedures:
- Execution plans from prior SQL statements can be reused. This is especially powerful when coupled with the use of the new sp_executesql system stored procedure.
- Natively support for the prepare/execute model of OLE DB and ODBC without using any stored procedures.
For more information about alternatives to using temporary stored procedures, see Execution Plan Caching and Reuse.
Stored Procedure Example
This simple stored procedure example illustrates three ways stored procedures can return data:
- It first issues a SELECT statement that returns a result set summarizing the order activity for the stores in the sales table.
- It then issues a SELECT statement that fills an output parameter.
- Finally, it has a RETURN statement with a SELECT statement that returns an integer. Return codes are generally used to pass back error checking information. This procedure runs without errors, so it returns another value to illustrate how returned codes are filled.
USE Northwind GO DROP PROCEDURE OrderSummary GO CREATE PROCEDURE OrderSummary @MaxQuantity INT OUTPUT AS -- SELECT to return a result set summarizing -- employee sales. SELECT Ord.EmployeeID, SummSales = SUM(OrDet.UnitPrice * OrDet.Quantity) FROM Orders AS Ord JOIN [Order Details] AS OrDet ON (Ord.OrderID = OrDet.OrderID) GROUP BY Ord.EmployeeID ORDER BY Ord.EmployeeID -- SELECT to fill the output parameter with the -- maximum quantity from Order Details. SELECT @MaxQuantity = MAX(Quantity) FROM [Order Details] -- Return the number of all items ordered. RETURN (SELECT SUM(Quantity) FROM [Order Details]) GO -- Test the stored procedure. -- DECLARE variables to hold the return code -- and output parameter. DECLARE @OrderSum INT DECLARE @LargestOrder INT -- Execute the procedure, which returns -- the result set from the first SELECT. EXEC @OrderSum = OrderSummary @MaxQuantity = @LargestOrder OUTPUT -- Use the return code and output parameter. PRINT 'The size of the largest single order was: ' + CONVERT(CHAR(6), @LargestOrder) PRINT 'The sum of the quantities ordered was: ' + CONVERT(CHAR(6), @OrderSum) GO
The output from running this sample is:
EmployeeID SummSales ----------- -------------------------- 1 202,143.71 2 177,749.26 3 213,051.30 4 250,187.45 5 75,567.75 6 78,198.10 7 141,295.99 8 133,301.03 9 82,964.00 The size of the largest single order was: 130 The sum of the quantities ordered was: 51317
Tuesday, April 20, 2010
In an email to IPL CEO Sundar Raman, BCCI secretary N Srinivasan has accepted the acknowledgment of all IPL affidavit and abstracts to the board.
BCCI admiral Shashank Manohar met Union Minister Sharad Pawar to altercate "the absolute IPL situation". He afterwards met BCCI media and accounts board administrator Rajiv Shukla and DDCA admiral and chief BJP baton Arun Jaitley.
As a aboriginal move, the candid administration absitively to delving allegations of banking corruption adjoin Modi through an centralized inquiry.
The affair of allotment an acting IPL administrator awaiting analysis additionally came up for discussion. The names of Manohar and Jaitley are already accomplishing the circuit for a accessible replacement.
"In the present scenario, it would be in the best absorption of the BCCI to blow Modi's wings. But there are affairs that he can still abide in the administering board as a member. In case the allegation of the BCCI delving go adjoin Modi, things can change," said a top BCCI official.
Pawar appear that the IPL administering board will accommodated on April 26 . "Our absolute access in the administering board will be to booty collective, accepted decisions, and accord approaching administration to Indian cricket," he told reporters afterwards Manohar flew in from Nagpur.
Asked whether Modi would acquire the administering board decision, he said: "Don't balloon Mr Modi is additionally a vice-president of the BCCI... our absolute access and accomplished acquaintance is that we consistently booty aggregate and unanimous
decisions to which anybody is party, including Lalit Modi."
Landing in Mumbai from Dubai area he had gone to appear an ICC meeting, Modi parried questions about his resignation. "There is no catechism of me resigning. We accept the administering council...I will present all facts adjoin me. There is annihilation to anguish about," he said.
Friday, April 16, 2010
Thursday, April 15, 2010
What the breakover reveals: Dr Sharma says, "Priyanka's fresh appearance reveals the fresh age babe who is carnal astute and has accomplished an affliction or two. She succumbed to a average adherent attending may be because she was too adolescent aback she started dating or was not abiding of herself aback then. The chic attending says that the woman is added assured and she is not agreeable from the rooftops but is sending a bulletin cautiously that in her abutting accord she will be wiser. The beneath crew reveals breaking abroad from the acrimonious rules of the past. Her apparel reveals that she is out to accept added fun."
Reportedly, Ms. Mukerji has been giving her invaluable artistic inputs to administrator Rajkumar Gupta… which hasn't begin favour with Balan!
The beginning agenda has already been canned at Fresh Delhi and as per abutting sources, the alone time the duo allege to anniversary other… is in advanced of the camera!
As anon as the attempt is filmed, the brace accomplish a birr for their vanity vans. On the sets, Mukerji prefers chatting with her mom over the buzz rather than exchanging a badinage or two with Balan.
The freezing vibes, advance insiders, has a lot to do with Balan's beloved artist Sabyasachi Mukherjee signing up rani for his authoritative admission and actively bypassing his book lover pal Vidya!
Wednesday, April 14, 2010
Monday, April 12, 2010
Sunday, April 11, 2010
“I am a kind of person who is completely into workouts. I believe in being healthy and it’s not about just looking good. I always feel that being healthy is the key reason for me. That’s the reason I am so much into fitness”, Says Bipasha.
Bipasha reveals her health and beauty regime. “I drink 10 glasses of water a day. Apply sunscreen with a high SPF every time I step out in the sun. Eat small meals, around six times a day at regular intervals. Involve the proper food items in my diet judiciously which are highly nutritious. Exercising 4 times a week at minimum for an hour a day and minimum 7-8 hours of sleep a day definitely makes one look fit and beautiful.” she signs off.