Sunday, December 18, 2011

VRO VRA - 7235 Vacancies Andhra pradesh No Interviews

3 comments:
VRO, VRA 7235 Vacancies in Andhra Pradesh
Andhra Pradesh Revenue Department invites applications for the recruitment of Village Revenue Officer (VRO) and Village Revenue Assistant (VRA) vacancies in various districts of Andhra Pradesh. Eligible candidates may apply online for the vacancies:

VRO, VRA Vacancies: 7235
VRO Total Vacancies: 1172
VRA Total Vacancies: 6063

Districtwise vacancies are given below:

Srikakulam:
VRO Posts: 26 Posts
VRA Posts: 125 Posts Click here for Details

Vizianagaram:
VRO Posts: 38 Posts
VRA Posts: 126 Posts Click here for Details

Visakhapatnam:
VRA Posts: 102 Posts Click here for Details

East Godavari:
VRO Posts: 35 Posts
VRA Posts: 422 Posts Click here for Details

West Godavari:
VRA Posts: 466 Posts
VRO Posts: 49 Posts Click here for Details

Krishna:
VRO Posts: 39 Posts Click here for Details

Guntur:
VRA Posts: 289 Posts
VRO Posts: 269 Posts Click here for Details

Prakasam:
VRO Posts: 75 Posts
VRA Posts: 267 Posts Click here for Details

Nellore:
VRO Posts: 26 Posts
VRA Posts: 225 Posts Click here for Details

Chittoor:
VRO Posts: 79 Posts
VRA Posts: 283 Posts Click here for Details

Cuddapah
VRO Posts: 23 Posts
VRA Posts: 190 Posts Click here for Details

Anantapur:
VRO Posts: 137 Posts
VRA Posts: 203 Posts Click here for Details

Kurnool:
VRO Posts: 58 Posts
VRA Posts: 85 Posts Click here for Details

Mahabubnagar:
VRO Posts: 23 Posts
VRA Posts: 458 Posts Click here for Details

Rangareddy:
VRO Posts: 59 Posts
VRA Posts: 194 Posts Click here for Details

For Hyderabad:
VRO Posts: 34 Posts
VRA Posts: 26 Posts Click here for Details

Medak:
VRO Posts: 08 Posts
VRA Posts: 252 Posts Click here for Details

Nizamabad:
VRO Posts: 21 Posts
VRA Posts: 207 Posts Click here for Details

Adilabad:
VRO Posts: 15 Posts
VRA Posts: 179 Posts Click here for Details

Karimnagar:
VRO Posts: 60 Posts
VRA Posts: 464 Posts Click here for Details

Warangal:
VRO Posts: 45 Posts
VRA Posts: 353 Posts Click here for Details

Khammam:
VRO Posts: 27 Posts
VRA Posts: 193 Posts Click here for Details

Nalgonda:
VRO Posts: 26 Posts
VRA Posts: 348 Posts Click here for Details

Age Limit: 18-39 Years for VRO, 18-35 Years for VRA. Upper age limit relaxations for SC/ST/BC are 5 years.

Educational Qualification: Intermediate from AP Intermediate board or equivalent exam for VRO SSC from AP and Secondary Education board or equivalent exam for VRA:

Selection Process: Written Test.

Application Fee: Rs 200/- for general candidates and Rs 100/- for SC/ST candidates through any of the E-Seva / Mee-Seva /AP online centers, and obtain acknowledgement.

How to Apply: Apply online from 07/12/2011-27/12/2011.

Closing date for application fee: 29/12/2011


VRO/VRA Advertisement

Apply Online

AP Online Centers

E-Seva List

Wednesday, November 9, 2011

Windows media player -Server Execution failed- Solved

2 comments:
Windows media player -Server Execution failed- Solved
Today I got trouble, playing windows media player 12 (Running on Windows 7). First I troubleshoot by installing and uninstalling windows media player. But unfortunately nothing works for me. Then I simply did the following thing to work like a charm…
Follow and Enjoy…Windows 7 Ultimate…

I would like to confirm if WMP can load from C:\Program Files\Windows Media Player\wmplayer.
To further troubleshooting, please perform the following steps:
Rename the WMP networking information folder
====================================
1. Close Windows Media Player.
2. Click the Start Button, type "%userprofile%\appdata\local\Microsoft\Windows Media" (without quotation marks) in the Search Box and press Enter.
3. In the open folder, right-click the folder 12.0 and choose Rename. Rename the folder to 12.0.bak.
Register the WMP components
==================
1. Close Windows Media Player and any other windows.
2. Click Start, All Programs, Accessories
3. Right click "Command Prompt" and choose "Run as administrator", accept the UAC prompt.
4. Type the following commands and press Enter after each line.
regsvr32 jscript.dll
regsvr32 vbscript.dll
exit
Set WMP default
===============
1. Click the Start Button, choose Default Program in the right pane.
2. Choose Set your default programs.
3. Click Windows Media Player in the Programs pane.
4. Click Set this program as default, and then click Choose default for this program.
If the issue persists, please try repairing the system as below:
In-Place upgrade (Repair install)
===========
1. Start the computer by using the current Operating System.
2. Insert the Windows 7 DVD in the computer's DVD drive.
3. Use one of the following procedures, as appropriate:
If Windows automatically detects the DVD, the Install now screen appears. Click Install now.
If Windows does not automatically detect the DVD, follow these steps:
a. Click the Start Button, type Drive:\setup.exe in the start search box and then click OK.
Note: Drive is the drive letter of the computer's DVD drive.
b. Click Install now.
4. When you reach the "Which type of installation do you want?" screen, click Upgrade.


Disclaimer | Home | Gsv Films Gsv Pics | Gsv Vids | Techno zip |  Divine-Thought

Thursday, October 20, 2011

Burning Data DVDs using Windows Media Player 11

1 comment:
Burning Data DVDs using Windows Media Player 11 in five easy steps

 Data DVDs can contain any data, be it games, music and/or videos. However, they are only readable
using a computer, so if you burn an mpeg-2 (DVD format) file to your DVD, your DVD player will not
be able to play it.

Windows Media Player 11 allows you to burn Data DVDs only.
1. Open Windows Media Player 11

2. Click the Burn tab, click the arrow below the Burn tab, and then click the type of disk you want to burn (Data DVD)

3. Insert a blank DVD and make sure the proper DVD-burning drive is selected

4. Select the files you wish to burn

5. Click Start Burn

That's all.

Happy DVD Burning..

Tuesday, October 18, 2011

Bsnl Broadband Problem Soloutions

No comments:
BSNL Broadband - problems and its soloutions - Error  numbers and its detailed information
Problem Error-678
Description This is most common problems. It is due to poor connectivity. Problem can be anywhere between B.RAS - Tier 2 - DSLAM - Modem - PC of the customer.
Remedy Switch off / Switch on Modem (Power Switch at the back of modem ) and wait for 2 minutes. Then retry.

If problem is not solved then Reset Modem [Back pin (in the hole) to be pressed in switched ON condition]
[Note : Link PC in black type Modem or WAN / LAN in white type Modem will go Off and then ON and system may be stable. Then retry.
If problem is still not solved then
a)Check link lamp in Black type Modem or WAN lamp in White Modem. If it is blinking, then it is line problem.
b)Check Modem to splitter connectivity.
i) Jack in & Jack out the cable of / to the modem and to the splitter
ii)Jack in & Jack out the telephone connection of the splitter.
If lamp is still blinking - then it is due to poor line condition / fault.
The case has to be referred to Area Broadband Team for attending the fault.

Problem Error-691
Description User id and Password problem.
Remedy The case is to be referred to Central Broadband Team (08.00 AM to 08.00 PM). Central Broadband Team will reset the password and intimate that password has been reset.

Problem Error-769
Description LAN not enabled.
Remedy

The LAN Card has to be enabled by following the steps given below.
i)Go to Desktop.
ii)Click "My Network Place".
iii)Select Properties.
iv)Click "Enable the local network".

Problem Error- 797
Description Modem or LAN driver problem
Remedy Reset the Modem (in on condition ) by pressing button available in the backside hole of the modem and wait for 2 mintues and then log on. If the problem is not solved then call your vendor to check computer LAN Card driver.

Problem Error-718
Description i)Peak Hour - This problem occurs if loading is high on the system and number of customers exceed the call handling capacity of B.RAS.
ii)Slack Hour -This problem occurs if PPPoE is corrupted.
Remedy i)Peak Hour - Please try after some time.
ii)Slack Hour - Please load PPPoE again.

Problem Error - 630-633
Description Computer LAN Card problem.
Remedy LAN Card has to be changed.

Problem OSP Internet is working, Data One is not working
Description Cable Internet is working. Tata / Reliance is working but Data One is not working. Data One is working through LAN Card. Problem can be seen by observing PC lamp (in black modem) LAN lamp ( in white modem) which might not be glowing or may be blinking.
Remedy LAN Card has to be changed.

Problem Site not opening from Data One
Description From VSNL sites are opening, Dial-Up sites are opening but from Data One sites are not opening. Probable reasons
i)Internet explorer is not supporting the Pope (may be pirated OS).
ii)Virus corrupting Internet explorer.
Remedy The customer is requested to set it right.

Problem BSNL BB DNS server may be having problem.
Description DNS is not responding.
Remedy Ping-61.1.96.69 or 61.1.96.71 and check up whether DNS is responding.

Broadband Utilities
To see usage details Log in to Broadband, Go to 10.240.43.216 or 10.150.128.195.
Click on Service Record. Details of the current month usage and previous month will be shown.

To change password Log in to Broadband, Go to 10.240.43.216 or 10.150.128.195.
Click on 'change password', give 'Old password', 'New password' and confirm. Password will be changed.

Trouble shooting of Broadband Modems

White Modem
After switch ON wait for 2 to 3 minutes to get the modem stable.
If telephone line / dial tone problem, contact '198'.
If Broadband / Internet not working, contact '1600-424-1600'.

Lamp features
i)Power - ON - Red
ii)WAN -Yellow
when stable OK
when blinking Data transfer
when not stable Line is faulty
iii) LAN - Green
when stable OK
when blinking fast Data transfer
when blinking slow Modem to PC link problem
iv)PPPoE - No use.
Reset pin is at backside Hole - to be reset whenever required in ON condition of the modem.

Black Modem
After switch ON wait for 1to 2 minutes to get the modem stable.
If telephone line / dial tone problem, contact '198'.
If Broadband / Internet not working, contact '1600-424-1600'.

Lamp features
i)Power - ON - Red
ii)WAN -Yellow
when stable line is OK
when blinking slow, line trouble.
iii)PC - Green when stable OK
PC - Off- PC not connected
iv)Data - Green - Flashing - Data transfer
Reset pin is at backside Hole - to be reset whenever required in ON condition of the modem.

Top 30 Mobile Wonderful Websites

1 comment:
Mobile internet usage is picking up daily. According to recent studies ,most of the people are depending on mobile services like sms, internet, mms and voice mail box. Among all those services Mobile internet is an attractive step to allow the people to share their instant thoughts. Keeping this in mind most of the mobile companies are adding so many features to the mobile.....

Today I present the “top 30” mobile websites as recorded on Cantoni.mobi. These results are captured by my MyBlogLog community widget which reports on not just page views, but links clicked exiting the site.

The same caveat applies: any mobile browser with Javascript either disabled or not present is not tracked. Regardless, the overall trend should still be accurate.

Over the last 6 months, we recorded a total of about 180,000 links that were followed (an average of about 1,000 per day). Here are the top 30 mobile websites, in order:

Monday, August 15, 2011

Software Testing process in 5 Easy Steps

No comments:

Testing in simple steps:

• Step-1:Requirements
• Step-2:Test planning
• step-3:Test case writing
• step-4:Test case execution
• step-5:Test sign-off 


Requirements

First and most important input for testing is requirement. Requirements are mostly gathered by the Business development team. These requirements are really not of technical requirements. Language is very much understood by non-technical users. Later on Project Manager/Programme Manager comes up with the requirements in proper format commonly known as functional specifications/business requirement specifications. These documents generally are doc format.


Tester's role:

It's really important for test team to participate in requirement review process.This helps the entire product team to start in right track from the beginning. Output expected from a tester here in review meetings are:
• See if requirements are testable?
Example: If Requirement says "Web pages must look beautiful". How will you test if web pages are beautiful? Can you answer this? So test team points out these kind of issues in requirement reviews.
• Make sure requirements are clear,concise and not contradictory.
• Understand the requirements clearly,ask questions.As later in cycle tester's need to test the application against the requirements.
This is the first stage where tester test the requirements.


Test Planning :

Once you are done with requirement reviews then PM/PO will come up with the final version of requirement specs.
Now based on the final requirement specs test team will plan there testing activities like coming up with test strategy, test plan writing etc...
Test plan is mostly developed by test lead or senior test member. The test planning will mainly answer the following:
• What to cover :functional testing, performance testing, load testing, accessibility testing, regression testing etc..?
• Time line for above.
• who will do what?
• Only manual testing or Automation?
• If Automation then what percentage?
• Dependencies?
• Test activities & timeline: like test case writing, test execution, bug bash, test sign off etc
• Test sign off criteria.

Test case writing

Once test plan is written it go through some review process and final document gets publish in the team. Now testers start writing test cases for the features/functionality. Good way of writing test cases is to first write test case outlines (TCO's) and then convert those tco's in detail test cases.
TCOs are basically one line statement about a test scenario that test intend to test.
Further tester breaks the TCOs in multiple test cases with all details like "Steps", "Expected results", "Priority" etc..
• To see if there is a good test coverage for scenarios.
• To see if steps provided in test cases are clear and concise."
Tools used for Test case writing : Some companies use word or excel format and rest uses Test management tools.
Other activities that always go along with test case writing is test case update where testers Add/edit/delete test cases because of following reasons:
o Wrong test cases written by a tester.
o Some changes in existing requirement which may require editing of existing test case or adding new test cases.
o Missed scenarios by testers.
Test Execution/Test Pass/Test Run

Once the Developer are done with coding. Test team starts the action:

  • o Developer release a build for testing.
  • o Test team will now run BVT tests.
  • o Once the BVT tests are passing. Test team will accept the build.
  • o Now the actual test pass starts.
  • o Test team will run the tests they have written.
  • o Test will mark the test cases Pass/Fail accordingly.
  • o Test will log bugs for the failed test cases.
  • o Test will verify the fix for resolved bugs and accordingly close the bugs.
  • o Test team will do the complete test pass again if required or do a test of some selective test cases to make sure that there are no regression bugs.
These activities are part of every milestone or iterations. Once test passes are complete.
Next step is Test Sign-off.


Test Sign-Off

Now the time comes when test team will do the test sign-off. Normally the test sign-off criteria is mentioned in the test plan. It's being done by the QA head/test manager/lead.

Create Numerous Gmail ids with one

2 comments:

Gmail provides number of features and number of shortcuts to access easily, by just tapping the keyboard.

My suggestion is dont create Number email id's to track your daily work, school, office, friends, relatives respectively .You can create one mail id which will caters all your needs.
If you can create somename@gmail.com, give this by just changing as some.name@gmail.com
and now go to filters in the Gmail and place the email what you have given there in To: section and then track them down... Thats. .all...

Let’s say that your email address is ‘GeorgeBush@gmail.com’, basically everything sent to any of the following email addresses will be forwarded to your primary email.

GeorgeBush@gmail.com
G.eorgeBush@gmail.com
Ge.orgeBush@gmail.com



GeorgeBus.h@gmail.com
GeorgeBush@googlemail.com
G.eorgeBush@googlemail.com
Ge.orgeBush@googlemail.com



GeorgeBus.h@googlemail.com

And that’s not all, you can place as many dots as you want, it can be even something like ‘G.e.o.r.g.e.B.u.s.h@gmail.com’ and you’ll still get it on ‘GeorgeBush@gmail.com’


Additionally, I just also found out that you can embed random text to your email ID using ‘+’ sign. That is to say ‘GeorgeBush+anythingyouwant@gmail.com’ can be used as your email address, as well.

Ok I think you got it.

Now what ?

1. One email for every purpose

Instead of using different email addresses for various purposes (work, school, friends, etc.) you can use different variations of your Gmail and filter incoming mails by ‘sent to’ address. For instance, all incoming mail sent to ‘Name.Surname@gmail.com’ can be put to folder ‘work’, messages sent to ‘NameSurname@gmail.com’ can be put to ‘friends’, ‘N.ameSurname@gmail.com’ can be used for newsletters, and so on.

2. Track/Block spammers

When signing up for some website, say thatwebsite.com, you can add thatwebsite to your Gmail user ID (eg. GeorgeBush+thatwebsite@gmail.com). This way you can block your subscription whenever you want and even identify those websites that distribute your email address to spammers.

Sunday, July 31, 2011

Top Tips to Cool your Hot Laptop

1 comment:
5 easy tips to cool a hot laptop
Laptop cool tips


Laptop computers naturally run hot (or at least very warm), and if they stay hot for prolonged periods of time they may overheat and cause serious damage. Whether or not you're experiencing the warning signs and dangers of your laptop overheating, the simple and inexpensive protective measures below will help keep your laptop cooler and make it work more reliably.

1. Adjust your power settings from "high performance" to a more "balanced" or "power saver" plan.


2. Use dust remover spray to clean out of the laptop's vents.


3. Use a laptop cooling pad that has a fan or two.


4. Keep your working environment or computer room as comfortably cool as possible.


5. Shut down your computer when not in use, and especially when you are not at home.

Friday, July 29, 2011

Recharge SUN DIRECT IN 8 EASY WAYS.

4 comments:
Sun Direct -  DIRECT TO HOME (DTH)
RECHARGE EASILY... BY THIS FOLLOWING STEPS...

HOW TO RECHARGE ?

This is a big question for all new users, so I would like to provide you all of this information on how to recharge your account, there are many simple ways of doing so, just go through the ones given below and choose the way which will be the most easy one for you.

1)Call 24x7 customer care centre to recharge your account.

The customer care nos. are as follows:

Tamil Nadu: 044-39407575
Andhra Pradesh: 040-39407575
Kerala: 0484-3940757
Karnataka: 080-39407575
Bihar: 0612-3940757
Chhattisgarh: 0771-3940757
Gujarat: 079-39407575
Delhi: 011-39407575
Jammu and Kashmir: 011-39407575
Haryana: 0184-3940757
Himachal Pradesh: 0177-3940757
Jharkhand: 0651-3940757
Madhya Pradesh: 0731-3940757
Maharastra: 022-39407575
Orissa: 0674-3940757
Punjab: 0172-3940757
Rajasthan: 0141-3940757
Uttar Pradesh: 0522-3940757
West Bengal: 033-39407575


2)Recharge through IVRS

How to recharge through IVRS?

Call 1860425 7575 to recharge over the phone.

Enter your customer ID to identify yourself to system.

Follow simple step-by-step instructions to enter your credit card / Recharge Voucher details
a)Credit Card
Enter the 16-digit card number
Enter 4-digit expiry date and year
Enter 3-digit CVV (last 3-digits on the back of your card)

b)Recharge Voucher
Enter the 16-digit Recharge Voucher number


On successful authentication by bank. atom IVR shall read out transation details.


3) Axis Call & Pay on atom

Axis Call & Pay on atom
To avail the service you need to register your mobile number at any Axis Bank ATM.
Registration process - You can register in two simple steps:

Step 1: Registration at ATM

You need to register your mobile number for this service at any Axis Bank ATM.

Click on 'REGISTRATIONS' on the ATM Screen.
Under 'REGISTRATIONS', click on 'AXIS CALL & PAY ON ATOM' to register your 10 digit mobile number.

Step 2: Call from Axis Bank to set PIN

After registering your mobile number at the ATM, you will receive a call for setting of the PIN.
You will receive a call from Axis Bank within 3-5 minutes. To set PIN, you will require to enter your last 4 digit Debit card number and expiry date.
You can set a 6 digit PIN of your choice.

Payment process

Call Customer Care on 1860 425 7575
Confirm the details of the payment to be made and choose 'Debit Card' option for payment.
Enter your Axis Bank debit card number and your 6-digit PIN.
Your payment will be made successfully.




4) Recharge via SMS


a) How to Recharge your account?
For Airtel, Aircel, Vodafone, Reliance and BSNL users, type RCG send to 58585.
For Spice users (only karnataka) send to 55858 from your mobile


b)How to purchase the Add-Ons?
For Airtel, Aircel, Vodafone, Reliance and BSNL users, type ADDON send to 58585.
For Spice users (only karnataka) send to 55858 from your mobile.


c)How to Register your Mobile number?
For Airtel, Aircel, Vodafone, Reliance and BSNL users, type RMNSmartcard number to 58585.
For Spice users (only karnataka) send to 55858 from your mobile


d)How to check your account balance?
For Airtel, Aircel, Vodafone, Reliance and BSNL users, type BAL send to 58585.
For Spice users (only karnataka) send to 55858 from your mobile.


5) Recharge via Mobile Application

Click on recharge via MOBILE, enter your phone no. you will receive a link, go to that link and download the ATOM application and then use it to recharge your account.
OR
SMS to 54959 from your mobile.


6) ONLINE RECHARGE

a) Recharge via recharge voucher
Buy a recharge voucher form a dealer
Go to
You are not allowed to view links. Register or Login to view.
Enter your "smart card number" as username
and "password"(default) as password
Then click on top up, enter the 16 digit pin, your account will be recharged.

b) Recharge via Credit / Debit Card / Net Banking
Go to
You are not allowed to view links. Register or Login to view.
and fill the details

c) Recharge through RECHARGEITNOW.COM
Steps to recharge
Log on to You are not allowed to view links. Register or Login to view.
Register for their services using your mobile number and E-mailID
Select Sun Direct as your service provider
Enter your Smartcard number and recharge it using your credit card,debit card or net banking.


7) Recharge via OXIGEN

To use Oxigen, you will have to register yourself on
You are not allowed to view links. Register or Login to view.
Then using net banking or credit / debit card you can recharge your sun direct account.



8) Recharge via EPRS


How to recharge your Sun Direct DTH account via EPRS?
EPRS provides two easy & convenient options to recharge your account.

a) TopUp your account:
A Sun Direct DTH Customer can directly Topup his account from an EPRS retailer
Steps to be followed:
Contact your nearest EPRS recharge centre
Provide the smart card ID and the fixed amount to the EPRS retailer.
The Retailer will do the recharge through sms or through the EPRS web application.
The retailer will get an immediate confirmation and collect the amount from you.
You will get a Email when you switch on the setup box.

b) Purchase Your Pin:
A Sun Direct DTH Customer can purchase easy recharge vouchers from EPRS retailers and do the recharge himself.
Steps to be followed:
Contact the nearest EPRS recharge centre
Provide the amount and quantity of the vouchers needed, to the retailer.
The Retailer will issue you an unique 16 digit pin no. using EPRS sms service or EPRS web application.
The Retailer can get up to 25 pins in a single purchase transaction.

A Sun Direct DTH Customer can use any of the following recharge modes to activate his account with the valid pin.

Call the Sun Direct Customer care number.
Provide the smartcard number and the 16-digit pin number
Your account will get recharged according to the denomination

SMS option
For Airtel, Aircel, Vodafone, Reliance and BSNL users, type
RCG
and send to 58585. For Spice users (only karnataka) send to 55858 from your mobile

Customer can also use the OEA Topup Engine.


FOR SUN DIRECT ONLINE SELF-CARE PORTAL

Go to
You are not allowed to view links. Register or Login to view.
Enter your "smart card number" as username
and "password"(default) as password.
Here you can recharge your account, subscribe to basic pack, choose add-on's and check all other details related to your sun direct account.

Guests cannot see images in this forum. To view images please REGISTER or LOGIN to see images.

Hope you find this information useful, for any queries you can mail me at gsvpkd  @ Gmail.com 


Monday, March 14, 2011

SQL Quick Ready reference in 5 steps -Tutorial

No comments:

SQL is a standard language for accessing databases.

Our SQL tutorial will teach you how to use SQL to access and manipulate data in:

MySQL, SQL Server, Access, Oracle, Sybase, DB2, and other database systems.

A standard SQL query might look like this:

SELECT first, last, occupation, sum(amount)
FROM tenngive
WHERE occupation = ``ROCKET SCIENTIST’’
GROUP BY first, last, occupation
ORDER BY 4 desc

Assume we are querying a database of campaign contributions. In English, the query means:

Show me the first and last names and occupations of donors who appear in the table called tenngive and the total amount of money that each gave -- but only if they listed their occupation as ``rocket scientist.’’ Return these records in reverse descending order of the summed amount to show which rocket scientist gave the most money.

The bold words represent the SQL ``template.’’ The remaining parts of the query -- such as ``last’’ and ``first’’ -- vary depending on the contents of your database and the questions you want to ask; however, if you can memorize the following template, you can write any basic SQL query. Just remember: You don’t have to use every piece of the template, but the pieces you do use must occur in this order. Read below for more information on what each means.

SELECT
FROM
WHERE
GROUP BY
HAVING
ORDER BY

1. SELECT: Every query must have SELECT

A database could have 100 or more fields of data, but you might only be interested in two or three of them. Use SELECT to pick the fields that you wish to display.

Also, use SELECT to calculate a new column of data -- for example, when you want to sum numbers or count items. (See additional information under GROUP BY.)


2. FROM: Every query must have FROM

You must tell the computer which table, or tables, you want to use. Use FROM to identify the table or tables that you are using. If you are using more than one table – in other words, if you are joining tables together – list each one on the FROM line, separated by a comma

3. WHERE: Using WHERE to filter records is optional – but it is mandatory for joining tables.

Filtering: A table might have 1 million records in it, but you might only be interested in records that fit a certain criteria -- for example, perhaps you only want to look at people whose last name is ``SMITH’’ or whose occupation is ``ROCKET SCIENTIST.’’ Example:

SELECT *;
FROM tenngive;
WHERE last = “VIKRAM”
Joining: In addition, when you link two or more tables together, use WHERE to establish the join. Example:

SELECT last, rest, amount, cand_name;
FROM tenngive, tncands;
WHERE id=cand_id


Data type: You must know each field’s data type. In filters, text info must be enclosed in quotations marks. Dates must be enclosed in French braces. Numeric data is not enclosed. Examples:

TEXT: SELECT *;
FROM columbia;
WHERE street = “RANGELINE”

DATES: SELECT *;
FROM hospital;
WHERE dob = #5/17/72#

NUMBERS: SELECT *;
FROM bonus;
WHERE amount = 1000

Equals, greater than, etc.: In addition to saying something equals a particular value, you can specify:
“greater than” with >
“greater than or equal to” with >=
“less than” with < “less than or equal to” with <= “not equal to” with <>


Wildcards: The wildcard in Access is the percent symbol -- * -- and it must be used with the word “like” in place of the equals sign. Example:

SELECT *;
FROM business;
WHERE company LIKE “*MICROSOFT*”

Boolean Logic: The WHERE line is the only place in SQL that you may use “and,” “or” or the symbol for not, which is <>. Examples:

SELECT *;
FROM tenngive;
WHERE last like “*HASLAM*” OR rest like “*HASLAM*”

SELECT *;
FROM tenngive;
WHERE last = “GRUBB” AND occupation = “ATTORNEY”

SELECT *;
FROM tenngive;
WHERE last <> “WOOD”
4. GROUP BY: Use GROUP BY only if you are performing math in the select line; you must GROUP BY all of the fields in the SELECT line except the math function.

This is the trickiest part of basic SQL. GROUP BY works with SELECT to allow the computer to do math. When you tell the computer to sum or count on the SELECT line, you must GROUP BY all other fields that appear in the SELECT line.

The most common math functions are sum() and count(*). Examples:

SELECT donor, sum(amount);
FROM gimme;
GROUP BY donor;
ORDER BY 2 desc

SELECT donor, zip, sum(amount);
FROM gimme;
GROUP BY donor, zip;
ORDER BY 3 desc

SELECT weapon, count(*);
FROM crime;
GROUP BY weapon;
ORDER BY 2 desc


5. HAVING: DON’T WORRY ABOUT THIS ONE – YOU’RE ALMOST NEVER HAVE TO USE IT

Although it is not often used, HAVING filters aggregate data, just as WHERE filters other records. For example, you might total the contributions given by each individual in a campaign finance database and choose to display only those HAVING a sum total greater than $5,000. Example:

SELECT last, rest, sum(amount);
FROM tenngive;
GROUP BY last, rest;
HAVING sum(amount) > 5000;
ORDER BY 3 desc



6. ORDER BY: ORDER BY is optional – it merely sorts your data. The default is alphabetical or chronological order. Stipulate DESC to get reverse order.

You can tell the computer to sort your records in any order you like -- for example, alphabetically or from highest number to lowest number or from lowest to highest. Use ORDER BY to sort your data. Use ORDER BY [field name] DESC if you want the records sorted in descending order (that puts the big numbers on top).

See examples in queries above.

NOTE: You can use numbers as shorthand to specify which field you wish to order by. In the example below, the records are ordered by the third item in the select line -- the summed amount:

SELECT last, rest, sum(amount);
FROM tenngive;
GROUP BY last, rest;
ORDER BY 3

References  & Downloads.
http://msdn.microsoft.com/en-us/sqlserver/default

Sunday, January 16, 2011

Toll Free Numbers for all your needs

1 comment:
We usually find free toll numbers for the following services is always difficult for your sake the below given phone numbers are for your purpose.

Airways
Indian Airlines – 1800 180 1407
Jet Airways – 1800 22 5522
SpiceJet – 1800 180 3333

Automobiles
Mahindra Scorpio – 1800 22 6006
Maruti – 1800 111 515
Tata Motors – 1800 22 5552
Windshield Experts – 1800 11 3636

Banks
AXIS BANK - 1800 233 5577
ABN AMRO – 1800 11 2224
Canara Bank – 1800 44 6000
Citibank – 1800 44 2265
Corporatin Bank – 1800 443 555
Development Credit Bank – 1800 22 5769
HDFC Bank – 1800 227 227
ICICI Bank – 1800 333 499
ICICI Bank NRI – 1800 22 4848
IDBI Bank – 1800 11 6999
Indian Bank – 1800 425 1400
ING Vysya – 1800 44 9900
Kotak Mahindra Bank – 1800 22 6022
Lord Krishna Bank – 1800 11 2300
Punjab National Bank – 1800 122 222
State Bank of India – 1800 44 1955
Syndicate Bank – 1800 44 6655

Cell Phones
BenQ – 1800 22 08 08
BSNL : 944 00 24 365
Bird CellPhones – 1800 11 7700
Motorola MotoAssist – 1800 11 1211
Nokia – 3030 3838
Sony Ericsson – 3901 1111

Computers/IT
Adrenalin – 1800 444 445
AMD – 1800 425 6664
Apple Computers – 1800 444 683
Canon – 1800 333 366
Cisco Systems – 1800 221 777
Compaq – HP – 1800 444 999
Data One Broadband – 1800 424 1800
Dell – 1800 444 026
Epson – 1800 44 0011
eSys – 3970 0011
Genesis Tally Academy – 1800 444 888
HCL – 1800 180 8080
IBM – 1800 443 333
Lexmark – 1800 22 4477
Marshal’s Point – 1800 33 4488
Microsoft – 1800 111 100
Microsoft Virus Update – 1901 333 334

Seagate – 1800 180 1104
Symantec – 1800 44 5533
TVS Electronics – 1800 444 566
WeP Peripherals – 1800 44 6446
Wipro – 1800 333 312
xerox – 1800 180 1225
Zenith – 1800 222 004

Couriers/Packers & Movers
ABT Courier – 1800 44 8585
AFL Wizz – 1800 22 9696
Agarwal Packers & Movers – 1800 11 4321
Associated Packers P Ltd – 1800 21 4560
DHL – 1800 111 345
FedEx – 1800 22 6161
Goel Packers & Movers – 1800 11 3456
UPS – 1800 22 7171

Education
Edu Plus – 1800 444 000
Hindustan College – 1800 33 4438
NCERT – 1800 11 1265
Vellore Institute of Technology – 1800 441 555

Healthcare
Best on Health – 1800 11 8899
Dr Batras – 1800 11 6767
GlaxoSmithKline – 1800 22 8797
Johnson & Johnson – 1800 22 8111
Kaya Skin Clinic – 1800 22 5292
LifeCell – 1800 44 5323

Manmar Technologies – 1800 33 4420
Pfizer – 1800 442 442
Roche Accu-Chek – 1800 11 45 46
Rudraksha – 1800 21 4708
Varilux Lenses – 1800 44 8383
VLCC – 1800 33 1262

Home Appliances
Aiwa/Sony – 1800 11 1188
Anchor Switches – 1800 22 7979
Blue Star – 1800 22 2200
Bose Audio – 1800 11 2673
Bru Coffee Vending Machines – 1800 44 7171
Daikin Air Conditioners – 1800 444 222
DishTV – 1800 12 3474
Faber Chimneys – 1800 21 4595
Godrej – 1800 22 5511
Grundfos Pumps – 1800 33 4555

LG – 1901 180 9999
Philips – 1800 22 4422
Samsung – 1800 113 444
Sanyo – 1800 11 0101
Voltas – 1800 33 4546
WorldSpace Satellite Radio – 1800 44 5432

Hotel Reservations
GRT Grand – 1800 44 5500
InterContinental Hotels Group – 1800 111 000
Marriott – 1800 22 0044
Sarovar Park Plaza – 1800 111 222
Taj Holidays – 1800 111 825

Insurance
AMP Sanmar – 1800 44 2200
Aviva – 1800 33 2244
Bajaj Allianz – 1800 22 5858
Chola MS General Insurance – 1800 44 5544
HDFC Standard Life – 1800 227 227
LIC – 1800 33 4433
Max New York Life – 1800 33 5577
Royal Sundaram – 1800 33 8899
SBI Life Insurance – 1800 22 9090

Mattresses
Kurl-on – 1800 44 0404
Sleepwell – 1800 11 2266

Investments/Finance
CAMS – 1800 44 2267
Chola Mutual Fund – 1800 22 2300
Easy IPO’s – 3030 5757
Fidelity Investments – 1800 180 8000
Franklin Templeton Fund – 1800 425 4255
J M Morgan Stanley – 1800 22 0004
Kotak Mutual Fund – 1800 222 626
LIC Housing Finance – 1800 44 0005
SBI Mutual Fund – 1800 22 3040
Sharekhan – 1800 22 7500
Tata Mutual Fund – 1800 22 0101

Paints
Asian Paints Home Solutions – 1800 22 5678
Berger Paints Home Decor – 1800 33 8800

Teleshopping
Asian Sky Shop – 1800 22 1800
Jaipan Teleshoppe – 1800 11 5225
Tele Brands – 1800 11 8000
VMI Teleshopping – 1800 447 777
WWS Teleshopping – 1800 220 777

Travel
Club Mahindra Holidays – 1800 33 4539
Cox & Kings – 1800 22 1235
God TV Tours – 1800 442 777
Kerala Tourism – 1800 444 747
Kumarakom Lake Resort – 1800 44 5030
Raj Travels & Tours – 1800 22 9900
Sita Tours – 1800 111 911
SOTC Tours – 1800 22 3344

UPS
APC – 1800 44 4272
Numeric – 1800 44 3266

Others
Consumer Helpline – 1800 11 4000
L’Or?al, GARNIeR – 1800 223 000
KONE Elevator – 1800 444 666
Indane – 1800 44 51 15
Aavin – 1800 44 3300
Pedigree – 1800 11 2121
Kodak India – 1800 22 8877
Domino’s Pizza – 1800 111 123
World Vision India – 1800 444 550
Telecom Monitoring Cell – 1800 110 420

Read more at TECK.IN: India Toll Free Numbers / Customer Care Numbers List http://teck.in/useful-toll-free-numbers-of-india.html#ixzz1B83rtQ9p

Saturday, January 1, 2011

Automate your Broadband Connection with this Utility

No comments:
It is quite easy to download during off peak hours as the speed will be better and it does not affect you browsing. If you own a BSNL connection, you can also avail the night unlimited facilty. Go through the following

1. Switch ON at 2.00 am (or any time you prefer)
Your BIOS may have this feature. If you are not an advanced user, better option will be to leave your PC ON on minimal power management mode. Like switch off the monitor and hard disk.
2. Connect to internet
Once your PC is ON, you need to connect to internet. Use a dialler for this purpose. If you connect to internet by simply switching ON your modem, you are using PPPoE mode and you need to change it to Bridge mode in your modem.
You can use any reliable auto dialler for this purpose. There are no. of methods for this function. Let us discuss a few.
*
Method 1:* For PPPoE mode
Imrans’s Broadband Helper Utility
More details : http://imran-utilities.synthasite.com/
*
Method 2: For Bridge mode
Create batch files for connecting and disconnecting internet. Use this to connect and reconnect at desired timings.
More details : http://www.indiabroadband.net/bsnl-b...tml#post154907 (NU Configuration)


3. Connect back to the net
It is all well done for a good sleep. But ISPs are not efficient enough to guarantee this. Our process may be disrupted if internet connection disconnects due to some line problems. Not to worry, not to worry. We can fix that too.
Imran’s Broadband Helper Utility automatically redials if there is a connection failure. Let us see a few other tools too.
ReConnect 1.5
More details: Download ReConnect 1.5 - ReConnect is a free utility that will automatically reconnect an internet connection when it disconnect - Softpedia
*
4. Schedule it
Now we need to find softwares that can download effectively during desired time slot. Files can be downloaded as two types,
1. Directly from websites,
2. As torrent downloads from seeds and peers.
*
Our regular download falls in the first category. If you are planning download bigger files, it is wise to choose torrents.
For regular downloads, we can use a download manager to automate the process. You can choose either Download Accelerator Plus (DAP) or Free Download Manager (FDM) for this purpose. Both can pause and resume downloads.
For torrents, utorrent is the best client. It is light and consumes lesser resources. It also provides search facility for torrent. utorrent was recently adopted by Bitorrent (Bittorrent invented Peer to Peer transfer).
*
5. Disconnect Internet
Imran’s Broadband Utility can disconnect your internet at any prescribed time.
*
6. Shutdown
You can either schedule a shutdown or use Imran’s Broadband Utility to shutdown at a prescribed time.
*
1 Step tip s
If you have an unlimited internet connection, simply download utorrent, DAP or FDM and schedule your downloads on a desired time.
Go here to download the latest version of utorrent.
µTorrent - a (very) tiny BitTorrent client
Go here to download the latest version of Download Accelerator Plus (DAP).
Download Accelerator Plus (DAP) - Free Download Manager
Go here to download the latest version of Free Download Manager (FDM).
Free Download Manager - absolutely free download accelerator and manager

Recent Posts