Archive for » 2010 «
Bride and bridegroom’s SQL queries-
Wedding Query in SQL Style -
HUSBAND’S QUERY-
CREATE PROCEDURE MyMarriage (
BrideGroom Male (25) ,
Bride Female(20) )
AS
BEGIN
SELECT Bride FROM india_ Brides
WHERE FatherInLaw = ‘Millionaire’
AND Count(Car) > 20 AND HouseStatus =’ThreeStoreyed’
AND BrideEduStatus IN (B.TECH ,BE ,Degree ,MCA ,MiBA) AND Having Brothers= Null
AND Sisters =Null
SELECT Gold ,Cash ,Car ,BankBalance
FROM FatherInLaw
UPDATE MyBankAccout
SETMyBal = MyBal + FatherInLawBal
UPDATEMyLocker
SET MyLockerContents = MyLockerContents + FatherInLawGold
INSERT INTOMyCarShed VALUES(’BMW’)
END
GO
Then the wife writes the below query:
DROP HUSBAND;
Commit;
“`*“`arun
…
One of the nice mail I received-
Bill Gates organized an enormous session to recruit a new Chairman for Microsoft Europe. 5000 candidates assembled in a large room. One candidate is our ramasamy.
Bill Gates: Thank you for coming.
Those who do not know JAVA may leave.
2000 people leave the room.
Ramasamy says to himself,
‘I do not know JAVA, but I have nothing to lose if I stay. I’ll give it a try !’
Bill Gates: Candidates who never had experience of managing more
than 100 people may leave.
2000 people leave the room.
Ramasamy says to himself
‘I never managed anybody by myself, but I have nothing to lose if I stay. What can
happen to me ?’ So he stays.
Bill Gates: Candidates who do not have management diplomas may leave.
500 people leave the room.
Ramasamy says to himself,
‘I left school at 15, but what have I got to lose ?’ So he stays in the room.
Lastly, Bill Gates asked the candidates who do not speak Serbo-Croat
to leave.
498 people leave the room.
Ramasamy says to himself,
‘I do not speak one word of Serbo-Croat but what do I have to lose ?’ So he stays
and finds himself with one other candidate; Everyone else has gone.
Bill Gates joined them and said ‘Apparently you are the only two candidates who speak Serbo-Croat, so I’d now like to hear you have a conversation together in that language.’
Calmly, ramasamy turns to the other candidate and says ‘ Endha ooru ? ‘
The other candidate answers, ‘ Thoothukudi pakkam, Neenga??!!!!! ‘
Madurai…. Tamilians rock.
“`*“`arun …
Eleven point something-
1. If time doesn’t wait for you don’t worry! Just remove the damn battery from the clock and Enjoy life!
2. Expecting the world to treat u fairly coz u r a good person is like expecting the lion not to attack u coz u r a vegetarian! Think about it.
3. Beauty isn’t measured by outer appearance and what clothes we wear,but what we are inside. So, try going out naked tomorrow and see the admiration!! 
!!
4. Don’t walk as if you rule the world,walk as if you don’t care who rules the world! That’s called Attitude…! Keep on rocking!
5. Every lady hopes that her daughter will marry a better man than she did and is convinced that her son will never find a wife as good as his father did!!!
6. He was a good man. He never smoked or drank, had no affair. When he died, the insurance company refused the claim. They said, he who never lived, cannot die!
7. A man threw his wife in a pond of Crocodiles? He’s now being harassed by the Animal Rights Activists for being cruel to the Crocodiles!
8. So many options for suicide: Poison, sleeping pills, hanging,jumping from a building, lying on train tracks, but we chose Marriage, slow death for sure!
9. Only 20 percent boys have brains, rest have girlfriends!
10. All desirable things in life are either illegal, banned, expensive or married to someone else!
11. 10% of road accidents are due to drunken driving. Which makes it a logical statement that 90% of accidents are due to driving without drinking!
…How to repair suspected mssql database-
When you connect your MSSQL server you may notice some database(s) in ’suspected’ mode and it doesn’t let you do anything. This is happening because of database corruption, server not properly shut down, etc.. To repair the ’suspected’ database you may need to run the following query in your Query Analyzer(for SQL 2000) or Management Studio (for SQL 2005 and 2008)-
EXEC sp_resetstatus databasenamehere;
ALTER DATABASE databasenamehere SET EMERGENCY
DBCC checkdb(databasenamehere)
ALTER DATABASE databasenamehere SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CheckDB (databasenamehere, REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE databasenamehere SET MULTI_USER
Note: Before running the query please make sure you have taken the copy of data and transaction log files to another location.
Your database is repaired now
…
Recent Comments