Select Edit All Records In SQL Server 2008

In SQL Server 2008, the default numbers of rows for selecting and editing records are 1000 and 200 respectively. Sometimes if the records are greater than 200 and you want to edit some record then you have to change the query to get all the records. This is time consuming and you have to repeat this exercise whenever the records are greater than 200. The solution for getting all the records for selecting and editing is given below in steps:

1- Open SQL Server 2008 Management Studio
2- Goto Tools
3- Click "Options"

Salient Features of New All India Time Table ‘Trains at a Glance’

New Time Table Comes into Effect from 1st July 2012

The Ministry of Railways has released its new All India Railway Time Table known as “TRAINS AT A GLANCE (TAG)” which has come into effect from 1st July, 2012.  In addition to this All India Time table, all the 17 zonal Railways have also released their zonal railway time tables which too have come into effect from 1st July, 2012.   Passengers are advised to refer to the new timings  w.e.f. 1st July 2012 before starting the journey.  The new Trains at a Glance will also be shortly uploaded on Railways’ official website i.e. www.indianrailways.gov.in. The salient features of Trains at a Glance-2012 are as under: 1.         Encouraged by the public response over the past few years all the user-friendly features of Trains at a Glance viz. how to read a table, route map, station index,  trains between important stations, station code index, Train number index,  Train name index, has been retained.

Amendment in Tatkal Scheme

Amendment in Tatkal Scheme

With a view to further improve the delivery of Tatkal tickets to passengers, the Ministry of Railways has decided that with effect from 10.07.2012 booking of Tatkal ticket will start at 1000 hours on the previous day of journey from train originating station instead of 0800 hours at present. No authorised agents, including agents of IRCTC and RTSAs/RTAs will be allowed to book Tatkal tickets from 1000 hours to 1200 hours. The existing restriction of not allowing these agents booking of general tickets on the opening day from 0800 hours to 1000 hours will also continue Source : PIB

New List of Postal Guide - By KAIRALI BOOKS SYNDICATE

KAIRALI BOOKS SYNDICATE, NEW DELHI

Books for Postmaster Grade I in PO’s 

1. V.K.Balan’s Master Guide for DC Exam for the Post of 
Postmaster Grade I in Po’s 2011-12 ed                                 Rs. 875/- 


Books for Postal Operations - For Detailed Study 
1. Nabhi’s RTI Act one should know 2011 ed                       Rs. 190/- 
2. Swamy CCS CCA Rule 2012                                                Rs. 300/- 
3. Swamy CCS Conduct Rule 2012                                          Rs. 175/- 
4. Swamy FHB Vol I 2009 ed                                                    Rs 390/- 
5. DOP’s FHB Vol II 1985 ed                                                   Rs. 200/- 
6. Upkar’s Computer General Awareness                             Rs. 40/- 
7. Upkar’s Latest General Knowledge 2011                         Rs. 120/- 
8. Postal Manuals Vol II, III, IV, V, VI, Pt.I, II,III, VII, VIII 
PO Guide Pt I, II, IV (Call for Prices) 

RENEWAL OF FAMILY PLANNING INSURANCE SCHEME W.E.F 1ST JANUARY, 2012

No.N.23011/68/2011-FW (Ply) 
Government of India 
Ministry of Health and Family Welfare 
Family, Welfare Policy Section

Nirman Bhawan, New Delhi 
Dated 27th December, 2011

Subject : Renewal of Family Planning Insurance Scheme w.e.f 1^st January, 2012-reg

The Family Planning Insurance Scheme (FPIS) was adopted as a National Policy complying with the directions of Hon’ble Supreme court to extend benefits to the acceptors of sterilization and was implemented form 29^th November, 2005. This insurance policy was being serviced by ICICI Lombard General Insurance Company from 1.1.2011 to 31.12.2011 and has again been renewed with the ICICI Lombard General Insurance Company for a period from 01^stJanuary, 2012 to 31^st December 2012. The coverage under the renewed Policy is as under:

Section		Coverage	Limits
I	IA	Death following Sterilization (inclusive of death during process of sterilization operation) in hospital or within 7 days from the date of discharge from the hospital

MODEL QUESTION FOR IPO EXAM - POSTAL MANUAL VOL II (Q No 51-68)

POSTAL MANUAL VOL II (Q No 51-68)

51.       The equipment of stationery for all office must be sanctioned by ______

            a)         DG Post                                             b)         Head of the circle

            c)         Head of the division                              d)         None of these                       Ans:b

  

52.       The divisional Supdt may sanction boat allowance, up to  Rs___in a month in any one case to postman, village postman and such other official who have to incur expenditure regularly on hire

            a)         500/-                                                   b)         1500/-

            c)         1000/-                                                 d)         2500/-                                     Ans:a

53.       The divisional supdt may sanction up tot Rs ___ in each case, non-recurring contingent expenditure, powers for which are not provided for specifically

            a)         5000/-                                                 b)         1500/-

            c)         4000/-                                                 d)         2500/-                                     Ans:a

Transfer & Posting of JAG Officers and Promotion & Posting of STS Officers

Dte issued the following transfers in IPoS Gr A cadre

01. Ms.Madhuri Dabral Sharma, 1989, DPS, Punjab Region posted as Director (Sports & Welfare), Postal Dte  on request hence no TA / TP.

02. Ms.Sukhvinder Kaur, 1991, Director, PTC, Saharanpur, UP posted as DPS, Punjab Region.

Adhoc promotions not exceeding 11 months from the date of issue.

03. Shri.Abhishek Singh, 2003 Adhoc, Uttarkhand Circle posted as Director, PTC, Saharanpur.

04. Shri.Ashok Kumar Yadav, 2004 Adhoc, Director, PTC, Darbhanga (designate) posted as Jt Director, RAK NPA, Ghaziabad.

05. Shri.Babu Lal Sonal, 2004 Adhoc, Rajasthan Circle posted as Director, PTC, Darbhanga

Release of Revised MNOP Script dated 27.06.2012

Revised MNOP for Speednet released on 27.06.2012.This script will contain the entire Hub Master data as per the requirement /modifications

Click here to Download

source: CEPT Mysore

INCENTIVGE OF Rs.50/- PER PASS PORT DELIVERY TO POSTMAN

NEW DELHI: The TOI campaign on the passport logjam has made the government put reforms on the fast track. In an unprecedented move, the ministry of external affairs on Thursday announced a 'Passport Mela' this weekend at many PSKs countrywide - the kendras will remain open on Saturday and Sunday and people can just walk in, without an appointment. This practice will continue till the entire backlog has been cleared.

In a special briefing to TOI, Raghavendra Shastry, adviser to external affairs minister S M Krishna, gave details of fresh measures that are expected to address the concerns raised by the people - and reported by this newspaper to help make the new passport application process smoother and transparent.

The ministry has also reviewed the online appointment process, and from Friday, an additional 30% slots are being released. This will take the number of daily slots in the capital from 1,650 to 2,050. Moreover, appointments will now be given for up to 30 days instead of 15. "This way, we believe we will be able to process 6 lakh applications in the country this year," said chief passport officer and joint secretary in MEA Muktesh Kumar Pardeshi.

"We have taken the suggestions given by TOI seriously and want people to know that we are working hard on them. There has been a huge backlog of applications due to the holiday rush, which is why we are having this passport mela. MEA is doing it for the first time in the country. This will help us smoothen the service in about six weeks from now," said Shastry.

"We will entertain walk-ins only on weekends. And people need not form queues early in the morning. They can come anytime after 10am," said Basant K Gupta, additional secretary, consular passport & visa division, MEA.

The ministry has reiterated its promise of revisiting its website. "There has been a lot of confusion over the passport application website. The older site, www.passport.gov.in is no longer functional but people have been visiting it. Therefore, we are going to redirect traffic from there to our functional portal, www.passportindia.gov.in. We are also going to prepare a fresh list of documents required for applying under various categories. There will be no ambiguity in %the process anymore," Gupta said.

Does this mean that there will be no more surprise demands for additional documents by PSKs? "Yes. TCS staff will no longer decide what documents are needed. Now, only government officials will check if all documents are in place and if anything else is required," said Gupta.

Act under British Rule - Study material for Various departmental Examination

Regulating Act, 
1773-First step taken by the British Government to control and regulate the affairs of the East India Company in India


Pitt's India Act, 1784 
It was introduced to remove the drawbacks of the Regulating Act


Charter Act, 1813 
Monopoly of the Company's trade abolished except trade in tea & trade with China

Up-gradation of GP of IPs...Update.

It is learnt that up-gradation of Grade Pay of Inspector Posts from Rs. 4200/- to Rs. 4600/- file is returned by Ministry of Finance to DOP with query. The representative of Department of Posts is likely to meet the concerned officer of MOF in this week for detailed discussion in the matter.   

source : http://ipaspmhandgoa.blogspot.in/

LIMIT FOR RECEIVING REMITTANCES THROUGH INTERNATIONAL MONEY TRANSFER SERVICE TO A SINGLE INDIVIDUAL BENEFICIARY IS RAISED FROM 12 TO 30.

Limit for receiving remittances through International Money Transfer Service to a single individual beneficiary is raised from 12 to 30.

Quick facts about money transfer service

01) Money Transfer Service Scheme ( MTSS ) is a quick and easy way of transferring personal remittances from abroad to beneficiaries in India.

02) Only personal remittances such as remittances towards family maintenance and remittances favoring foreign tourists visiting India are permissible.

The system envisages a tie-up between reputed money transfer companies abroad and agents in India who would disburse the funds to the beneficiaries at ongoing exchange rates. Such Agents can be Banks (Authorised Dealers) or Full Fledged Money Changer or registered Non-Banking Financial Company (NBFC), IATA approved Travel agents ( having minimum net worth of Rs.25 lakhs ) with prior RBI approval.

Saving Schemes Information & Maturity Values w.e.f 01.04.2012

source:sapost

How to import facebook friends into google+?

Almost everyone of us have a facebook account and we all have built our friends, colleagues and or other circles over there. Now switching to Google+, since facebook doesn’t support export of friends, its harder and time consuming to invite them one by one.

Let’s save some time and migrate facebook friends to google+ in under 5 minutes.

Here we have written a step by step guide of how to export your facebook friends and then import friends into your google+ account.

Here are the steps

• Use an existing Yahoo! account or create a new one and login into Yahoo! mail
• Within Yahoo mail, Click on the Contacts tab
• Under Popular Tools section, you’ll find a link for Import Contacts, click on Import Contacts
• It will take you to a page with icons of Facebook, Gmail, Windows Live, Others….

10 Most Useful Microsoft Word 2010 Tips & Tricks

Microsoft Word 2010 is one of our favorite text editors. With such a big array of features, Microsoft Office Word 2010 can look complicated. There are many hidden tricks and shortcuts that make text editing easier. Here are some tips I think will help you when you are using Microsoft Word 2010.

Microsoft Word 2010 Tips And Tricks

1. Vertical Selection Of Text

Normally, we select a character, a word, a sentence or a paragraph. All these selections are horizontal selections. Sometimes you may need to select vertically. For example, if your text has numbers in the beginning, you may want to select only the numbers to delete them at one go (see figure).

Alan Mathison Turing's 100th birthday

Today Google celebrates the 100th birthday of computer genius Alan Mathison Turing (23 June 1912 - 7 June 1954) with an attractive doodle. He is also known as the founder of computer science whose work played a significant role in breaking the wartime Enigma- enciphered messages. 

Alan Turing, born in London, from his early years showed deep interest toward science and mathematics. As he grew, Turing showed exceptional ability in solving advanced problems. His innovative mind conducted several test and also worked on the design of the Automatic Computing Engine (ACE). In 1946, he presented a paper which is known as the first elaborate design of a stored-program computer. 

His life is full of achivements and because of this extraordinary work he was appointed Reader in the Mathematics Department at the University of Manchester in 1948. His contribution in mathematics and 'Computing machinery and intelligence' are still considered to be significant work. 

Turing was convicted of his homosexual actions as criminal act in the United Kingdom in 1952. After two years of conviction he died from cyanide poisoning which was believed to be a suicide. 

GOVT CONSIDERING ACTION AGAINST OFFICERS WHO ARE YET TO SUBMIT ANNUAL IPR

Irked over non-submission of property details by some bureaucrats, the government is considering strict action, including withholding of annual increment, against the defaulters.

The government has already issued repeated reminders to a number of officials of Central Secretariat Service (Under Secretary and above level) seeking their Immovable Property Returns (IPRs).

Despite this, some of them have not submitted IPRs. It has been noted that many of them give details of the returns much beyond the due date which cause a lot of managerial inconvenience. The government is considering strict action against some officials,” a Department of Personnel and Training (DoPT) official said.

Tips To Protect and Secure Your Privacy On Twitter

Twitter is one of the most popular and addictive social networking sites today, apart from Facebook. Originally thought of as a micro blogging site, Twitter soon turned out to be a site where people started to share everything – from what they eat to what they think, their habits, their obsessions, their ups and their downs, what they are doing, what they intend to do and more. You can look at the timeline of any person and get to know many facts about him or her.

Is Protecting Your Tweets A Good Idea?

So how do you go about protecting your privacy on a site so seductive!? These tips that will help you stay secure and protect your privacy while using Twitter.

One of the methods to protect your privacy on Twitter is to protect your tweets. You can protect your tweets by visiting Settings. This way, people who are not following you cannot read your tweets. You also get to select who all can follow you. If you want to interact with limited people and with people whom you know, you can go ahead and protect your tweets.

10 Things To Do Before You Retire

Don’t put off today what you can’t afford to do tomorrow. In spite of the world wide pension crisis and a growing acceptance that we must plan and save for our retirement, the harsh reality is we are actually not saving enough. Research reports reveal that only 15% of the individuals are saving sufficiently for their retired life. Here are a few tips on things to do before you retire so that your retired life is more comfortable and enjoyable.

  

Get Rid of All Your Debts

If you are taking a housing loan, personal loan, car loan or any other loan make sure that you will be repaying them on or before your retirement. You need to choose the term of the loan in accordance with your retirement age. You can enjoy your retired life when you have 100% financial freedom, not when you have to repay your loans.

Protect Your Emergency fund

Emergency expenses can happen any time. But the possibility goes up during the old age. So we need to enhance the emergency reserve year on year based on the inflation and change in your expense levels. Emergency fund will give you a sense of security and also you need not touch your other investments during emergency where you need to pay pre-closure penalty. Also don’t forget to refill the emergency fund once you met an expense out of emergency fund.

Establish a Retirement Budget

You need to visualize your retired life well in advance and need to create a budget for your retirement. That is you will not be going to office. So the expenses on transport and clothes may come down. Also you will have more time to spend. You may need to spend more on leisure travel and health care.

Examine Your Cash Flow

SB ORder no 08/2012

Patches for Sanchay Post Version 6.6.1 ( dtd 21/06/2012 )

3	Online Transactions (9)	All systems with Sanchay Post Software, running the respective modules.	SP5\OT	21/06/2012
4	SOSB Online (5)		SP5\SOSB	21/06/2012

DBAnalyzer for Sanchay Post :

Download : http://tamilnadupost.nic.in/sdc/xfiles/DBAnalyzer.zip

Modified Assured Career Progression Scheme for the Central Government Civilian Employees

No.35034/10/2011-Estt. (D)

Government of India

Ministry of Personnel, Public and Pensions

(Department of Personnel and Training)

Establishment (D)

North Block, New Delhi

Dated : 13th June, 2012

OFFICE MEMORANDUM

Subject : Modified Assured Career Progression Scheme for the Central Government Civilian Employees - Clarification regarding grant of benefits of MACPS to officers who have later on inducted into Organized Group A Services -

In terms of clarification given o point of doubt no. 2 of Annexure of this Department's O.M. dated 09.09.2010, no benefits under the MACPS would be applicable to Group A officers of Organised Group A Services, as the officer under organized Group 'A' Services have already been allowed parity of two years on non-functional basis with the officers of the Indian Administrative Service (IAS). In this regard, this Department is in receipt of a number of references from various Departments in respect of officers who are deprived of the benefits of MACPS due to their induction into the organised Group A Services at a later stage of their service.

MODEL QUESTION FOR IPO EXAM

POSTAL MANUAL VOLUME II

(QNo 1-25)

1.         A criminal prosecution in a non-cognizable case should not be instituted without the previous sanction of the

            a)         Head of the Circle/Regional PMG                        b)         SSP/SP

            c)         Sub divisional inspector                             d)         None of these           Ans:a

2.         Which of the following is cognizable case?

            a)         Highway robbery                                          b)         Theft

            c)         Criminal breach of trust                              d)         All the above             Ans:d(129)

3.         Which of the following is non-cognizable case?

            a)         Theft                                                               b)         Cheating , forgery

            c )        Half murder                                                   d)         All the above             Ans:b(129)

4.         The security deposit account in POSB, PO certificates or Govt securities should be pledged by an official to the appointing authority, if of a

            a)         LSG states                                                     b)         HSG States

            d)         Gazetted status                                            d)         None of these           Ans:d(225)

Premium Products : Media Post , ePost, Direct Post

Media Post

Advertisement in Postal Buildings:

Posters brouchers, translites , display units etc. can be displayed inside a postal building. The materials has to be provided and fixed by the advertiser.

The rate for displaying advertisement :

HOW TO TAKE GOOD CARE OF YOUR LAPTOP COMPUTER

It is important to take care of your laptop to keep it in good shape; prevention is always better than cure. There are a number of easy things that you can do to keep your laptop in great shape; following these easy steps will help to ensure that it lasts longer and will need less maintenance. As an added bonus, many of the steps will also maintain your laptop’s speed.

Keep liquids away from your laptop. As tempting as it might be to drink coffee, soda, water or any other liquid near your laptop, accidents can happen all too easily. Spilled liquids may damage the internal components or cause electrical injury to the laptop. Short circuits can corrupt data or even permanently destroy parts. The solution is very simple: Keep your drinks away from your computer. Even if you’re careful, someone else might bump into your desk or you. Or you can use a cup with a cover on it, so even if it does spill, the liquid doesn’t go any where!

DETAILS OF LGO EXAMINATION 2012

Date for  Competitive Examination for promotion  of Lower Grade Officials to the cadre of Postal Assistants/Sorting Assistants for the year 2012  has been  announced 

The  main  points   are  furnished  below 

Eligibility  for LGO  Examination	Pattern and syllabus for the LGO        Examination
1. Postman/Mail Guard in the Pay Band-1 of Rs. 5200-20200 + Grade Pay of Rs. 2000 of the concerned unit/division  with 3 years of regular service in the  grade.	No  Of paper	Syllabus	Duration	No. of MCQs	Qualifying Marks
	Paper-I	General English/Hindi and  Grammar, Arithmetic & Tabulation	1 Hour	50	40% in each Paper for Gen. Category and 33%for SC/ST categor

SEXUAL HARRASSMENT OF WOMEN IN THE WORK PLACE – FAQ ON REMEDIAL MEASURES

1. Whether there is any Rule for Prohibition of Sexual harassment of Working Woman?

Yes Rule 3 C of CCS (Conduct) Rules, 1964 prohibits sexual harassment of any woman at her workplace.

2. What are the specific provisions of the Rule?

(1) No Government Servant shall indulge in any act of sexual harassment of any woman at her workplace.

(2) Every Government Servant who is in charge of a workplace shall take appropriate steps to prevent sexual harassment to any woman at such workplace.

Explanation: For the purpose of this Rule. ‘Sexual harassment’ includes such un-welcomed sexually determined behaviour whether directly or otherwise, as

(a) physical contact and advances;

(b) demand or request for sexual favour;

(c) sexually coloured remarks;

(d) showing any pornography; or

(e) any other unwelcome physical, verbal or non-verbal conduct of sexual nature.

3. What are the guidelines and norms to be mainintained to prevent and deal with cases of sexual harassment in working place?

GPF - FAQ

1.      What is the minimum contribution towards GPF subscription? Whether the amount can be altered by the DDOs?

Ø As per Rule 8(b), the subscription towards GPF should not be less than 6% of emoluments and not more than total emoluments. The DDOs are having no right to alter the subscription fixed by the Government servant. The subscription may be increased twice and reduced once at any time during the year. 

2.      What are all the reasons for which GPF advance can be availed?

Ø  One can take GPF Advance for the reasons of higher education of self, children, legal expenditure, religious vow, obligatory expenses towards betrothal, marriage and other like ceremonies, for purchase of consumer durables such as TV, VCR, washing machines, computers etc.

CCS (LTC) Rules, 1988 — Relaxation for travel by air to visit J & K EXTENDED 2 YEAR FROM 18/06/2012 TO 17/06/2014

The undersigned is directed to refer to this Department's O.M. of even No.
dated 18th  June, 2010 on the subject mentioned above and to say that the relaxation
for LTC travel to visit J & K under CCS (LTC) Rules, 1988 is extended for a further
period of two years w.e.f. 18th  June, 2012 subject to the following conditions



ORDER DOWNLOAD

source:saindiapost

Microsoft Announces Surface Tablets

Microsoft today unveiled Tablet PCs – Surface for Windows RT and Surface for Windows 8 Pro built to be the ultimate stage for Windows OS.

Surface tablet for Windows 8 RT running on NVidia’s ARM processor, and surface for Windows 8 Pro, running on Intel’s Ivy Bridge (using the i5 core) weighs 676 grams and is 9.3 mm thick..

Using a 10.6-inch ClearType HD display, Microsoft tablets includes USB 2.0, Micro HD, and microSD options for connectivity. It comes with 2×2 MIMO antennas which gives the strongest WiFi capability.Both Tablets has a multitouch keyboard and a trackpad and will come with either 64 gigabytes or 128 GB of storage.