Monday, 23 April 2012

How to Delete all records from all tables from Database

Following is the SQL query used to delete all records from all tables from Database. This is useful during development scenarios where you need to get rid of all the dummy records and insert a fresh data. SQL Query: Appropriate...

Search for a Text in whole Database SQL

Search for a Text in whole Database SQL Hi, There was a requirement to search for a text in the whole SQL database. found this Stored procedure very useful. though it is worth sharing... Resource: http://vyaskn.tripod.com/search_all_columns_in_all_tables.htm --...

Grant of Transport Allowance to the Running Staff only taking into account pay plus 30% of pay

GOVERNMENT OF INDIA MINISTRY OF RAILWAYS (RAILWAY BOARD)No. E(P&A) II-2011/RS-51 RBE No.5/2012 New Delhi, dated 17.04.2012The General Managers, All Indian Railways & Production Units etc., (As...

Procedure of sending SO_TO_HO files at Head Post Office

Procedure of sending SO_TO_HO files at Head Post Office 1. First ensure that following points.A] In Sanchay Post à Superviosr à PO name and Address --> New Form --> See the Your office and Head Post Office details...

Three postal employees, accomplice caught stealing parcels

New Delhi, April 22,2012(IANS): Four men, including three postal department employees, were arrested for stealing parcels from a post office van in the capital’s cantonment area, police said Sunday.According to police, out of the accused, Jai Bhagwan, 47, Shiv Shankar, 55, and Janardan Majhi, 47, were employees of the post and telegraph department. The fourth was identified as Vinod Kumar,...

Central Government releases fund for Delhi to award Post Matric Scholarship

Press Information Bureau Government of India Ministry of Social Justice & Empowerment 23-April-2012 17:28 IST Central Government releases fund for Delhi to award Post Matric Scholarship Ministry of Social Justice &...

Review of Speed Post Discount Structure and Operational Machanism

The following modifications have been made with effect from 01.05.2012 in Speed Post Discount Structure and Operational Machanism.  1.The power to offer the credit facility to customer generating revenue below Rs 10,000/-...

Manner of Delivery of Speed Post Articles containing Passports

It has been decided by the Ministry of External ffairs New delhi that the present modality of delivering the speed post artilce containing Pass port"either to the addressee or his/her authorised representative on behalf of the...

SB Order no 05/2012: Revision of Interest Rate in RD , VIII and IX Year NSC

SB Order No.05/2012  No.113-01/2011-SB Government of India Ministry of Communications & IT Department of Posts Dak Bhawan, Sansad Marg, New Delhi-110001. Date: 19.04.2012 To All Heads of Circles/Regions Addl. Director...

Trai: One paisa per second plan mandatory

NEW DELHI: The Telecom Regulatory Authority of India (TRAI) has asked all service providers to ensure that they offer their customers atariff plan of one paisa per second along with other offerings. The regulator in a tariff...