The next outbreak? We’re not ready | Bill Gates

Make the shopping online and get profit 50%

Items available at Less than half Price...Reduce Shopping expense to half...

                                           Products at half price!!  We are often seen this in Discount sales.. But now it is available in the year throughout..Just make some changes in shopping.It is possible to purchase any products online with the help of online sites from your smart phone,tablet or PC..you will get attractive discounts from these sites.you can buy things at a remarkable price through these online sites. however it requires some homework. list of some items which are  available at half price are given below.

Make the shopping online and save 50%

                                                     Reducing expense is same as earning money. know about some online shops and online stores which will help you to earn money by reducing the expense of shopping. the competition in the market helps the consumer in a positive way..now a days you can buy any items like books, cloths and electronic gadgets through online .it requires only a mobile phone with an internet connection to buy  any items at a lower price than anywhere else. use the opportunity and save money..

Order Cancellation and Easy Returns

                      It is also possible to cancel the order within a time limit, if you don't want the item. similarly you can return the product, if you don't like it or the product is faulty, or damaged..

                 whenever you go for shopping, make use of online shopping.this will help you to save money as well as your time..now let us find some products which saves 10 to 70% .

Items More than 50% OFF
Items More than 30% OFF

Is online shopping safe?

Smart online shopping

 When you shop online, make sure you are smart about the whole purchasing process-know who you are dealing with, know what you are buying, be confident you will get what you have paid for, and ensure that your account and credit card details are being dealt with safely.

There are many advantages to shopping online-you can shop at any time, you don't need to worry about parking and your purchases are delivered to your door! Online auctionscan be a lot of fun and can also help you find good deals.

But there are some security traps to watch out for. Use your common sense and some simple steps to ensure your online shopping is as safe as possible.

Use your common sense and trust your instincts

Most shoppers know the warning signs to look for when buying something in a shop-the same applies to shopping online. Be wary if:

• the website looks suspicious or unprofessional
• the website is offering bargains which look too good to be true, they often are, or
• you are not confident about their use of your information or that you will get what you pay for.

Before making the purchase

• Know who you are dealing with-check that contact details are correct.
• Know what you are buying-read the description of the product carefully-check the size, colour, value and safety of the product.
• Read all the fine print including refund and complaints handling policies.
• Check the currency, postage and handling and other charges-there may be extra charges you aren't aware of.
• Check the final cost before paying.

Making the payment

• Only pay via a secure web page (one that has a valid digital certificate) Look for the https at the beginning of the address bar and a locked padlock in the browser. Read more about digital certificates:Understanding digital certificates and why they are important to check (File size: 270Kb)
• Use a secure payment method such as PayPal, BPay, or your credit card. Avoid money transfers and direct debit, as these can be open to abuse.
• Never send your bank or credit card details via email-only via a secure web page.
• Always print and keep a copy of the transaction.

Online auctions

Online auctions can be a lot of fun and can also help you find good deals.

They also attract scammers. Scammers will often try to get you to deal outside of online auction sites. They may claim the winner of an auction that you were bidding on has pulled out and offer the item to you. Once you have paid, you will never hear from them again and the auction site will not be able to help you.

1. Always conduct transactions within the auction website and avoid private contact with buyers or sellers-scammers will often use this ploy to 'offer a better deal'.
2. Keep printed and/or electronic records of all bids, item descriptions, emails to and from the seller, and transaction records or receipts.
3. If the website uses a feedback rating system, check all comments left by previous buyers and sellers.
4. Use a secure payment method such as PayPal, BPay, or credit card (where charge-back can be used).
5. Only pay via a secure web page (one that has a valid digital certificate).
6. Avoid money transfers and direct debit, because they can be open to abuse.
7. Never send banking or credit card details via email-only use a secure web page for payment. For more information see Shopping online.
8. Always print and keep a copy of the transaction.
9. Consider using the insurance offered by the auction facility (or another suitable provider).
10. Check the information on auction websites to help potential buyers and sellers.
11. Take the time to read the information about ways to reduce the risk on the auction site and the terms and conditions of contracts entered into by bidders and sellers.

Google India Study reports numbers about online shopping in India

Google India Study reports numbers about online shopping in India; ‘Electronics’ Top Search but ‘Apparels’ most bought

Methodology

The report was compiled by combining data from Google Trends and online research conducted by TNS Australia with a sample size of 800 respondents on behalf of Google India in November 2012.

Demographic Profile

Gender: Male (63%), Female (37%), age group (18 to 50) with 71% respondents in the age group of (18 to 35). 89% users were heavy users of the Internet with 67% users having access to their own money and 33% having access to someone else’s money. The sample size had a monthly average household income of INR 55,051/-. The respondents were spread across Delhi (22%), Mumbai (24%), Kolkata (9%), Bangalore (17%), Ahmedabad (6%), Hyderabad (12%), Pune (7%) & others (2%).

Results

Online shopping in India, saw 128% growth in interest from the consumers in the year 2011 to 2012 in comparison to only 40% growth in 2010 to 2011, making 2012 the tipping point for online shopping in India.

In terms of product categories, consumer interest on Google search for apparels & accessories (30%) emerged as the second biggest product category after consumer electronics (34%).

Massive growth in niche product categories in 2011-2012 on Google search, in comparison to electronics, baby products, Home & furnishing, & health care saw over 2x growth and were also the fastest growing product category in terms of query volume on Google search.

As mobile internet user base grows in India, mobile phones is also becoming a contributor in the surge for online shopping with Google witnessing 2X growth in number of queries from mobile phones in the year 2011 to 2012. Currently, 30% of all shopping queries in India come from mobile phones. These trends were also validated with the help of a online research conducted by TNS Australia of the internet users in the age group 18 to 50 from Delhi, Mumbai, Kolkata, Bangalore, Ahmedabad, Hyderabad & Pune.

As per the research, 90% of online shoppers are planning to buy more products online which reflects on the positive experience of the users. In terms of top product categories ever purchased online:

• Apparels & accessories was among the top category (84%)
• Electronics (71%)
• Beauty & personal care (64%)
• Books (62%)
• Household products (61%)

The frequency of purchase was also higher for categories like apparels & accessories (34%), beauty & personal care (33%) products in comparison to electronics (28%). Which also makes these categories more profitable because of repeat purchase. In terms of converting more users to shop online, online ticketing emerged as the gateway, as it was easier to convert online ticket buyers to shop online.

Online ticket consumers were also likely to spend higher average amount of INR. 2347 on their first product purchase in comparison to INR 1626 for a internet users. Online ticket buyers were also seen to be more comfortable with the use of debit cards (24%), credit card (19%) and cash on delivery (55%). For regular internet users – cash on delivery was the most preferred mode of payment (74%), followed by debit card (18%) & credit card (5%).

In terms of motivators to shop online, the consumers highlighted cash back guarantee as the number one benefit, ability to give cash on delivery, fast delivery, great deals and access to branded products were highlighted amongst the other benefits of shopping online. The consumers also highlighted some barriers that deter them from shopping online – the number one factor was inability to touch and try the goods before purchase, fear of faulty products, fear of posting their personal and financial details online and the inability to bargain were cited among the other reasons.

Speaking about the insights and implications for the online shopping Industry players in India, Rajan Anandan, VP & Managing Director of Google India, said “With approximately 8 million Indians shopping online in 2012, online shopping industry in India is growing rapidly and will continue to see exponential growth. By looking at the trends in 2012, we expect 2013 to be a strong growth year for players who’re focussed on fast growing categories like apparels & accessories and niche product categories like baby products, home furnishings & health-nutrition. We expect the growth to come from outside of top 8 metros as was evident in our recently concluded “Great Online Shopping festival’ which saw over 51% of traffic from non-metros.”

Process to Debug a stored procedure using Visual Studio.net

Process to Debug a stored procedure


1. Open the Microsoft Visual Studio 2005 IDE. 

2. Select Server Explorer option from the View Menu as follows: 

 

3. From the Data Connections node, right click and select, 'Add connection'. Fill in the details to connect to the intended SQL Server and the database using the login who has a fixed server role, SysAdmin. Click on Test connection. Once the connection succeeds, the overall screen should look like the following. 

 

4. Expand the data connection just added, and navigate to the Stored Procedures node. 

5. Expand the Stored Procedures node and select the intended SP to be debugged. 

6. Right click and select open to view the source code of the selected stored procedure. 

7. Place a break point on the intended line of code where debugging needs to be started its usually the way .NET Developers perform. 

8. After performing the above steps the screen shot should look like the following. 

9. After performing the above steps the screen shot should like the following: 

 

10. Right click on the stored procedure from the 'Server Explorer' and select 'Step-Into Stored Procedure' as shown below. 

 

11. This action brings up the following screen shot. 

 

12. Enter the needful values and click Ok. The next shot will be the following. 

 

13. From here on, its usual .NET debugging stuff. Use Step-Into and Step-Over and Step-out from the shortcuts menu or pressing F11,F10, Shift+F11 

Wasn't that very simple. It made the life of DB developers much more comfortable. Had it not been available with SQL Server 2005 and VS 2005 IDE it would have been a nightmare to debug stored procedures remotely/locally. 

Happy Development and concentrated debugging. 

renaming any column in SQL Server

I often get request from blog reader for T-SQL script to rename database table column name or rename table itself.

The script for renaming any column :

sp_RENAME 'TableName.[OldColumnName]' , '[NewColumnName]', 'COLUMN'

The script for renaming any object (table, sp etc) :

sp_RENAME '[OldTableName]' , '[NewTableName]'

This article demonstrates two examples of renaming database object.

1. Renaming database table column to new name.

1. Renaming database table to new name.

In both the cases we will first see existing table. Rename the object. Test object again with new name.

1. Renaming database table column to new name.

Example uses AdventureWorks database. A small table with name “Table_First” is created. Table has two fields ID and Name.

Now, to change the Column Name from “Name” to “NameChange” we can use command:

USE AdventureWorks
GO

sp_RENAME 'Table_First.Name', 'NameChange' , 'COLUMN'GO

Following Fig. show use of SP_RENAME Command

You can see the column name “Name” is now changed to “NameChange”.

USE AdventureWorks
GOSELECT *FROM Table_First
GO

Following fig. verify that the column name has been changed.

2.Renaming database table to new name.

We can change the table name too with the same command.

sp_RENAME 'Table_First', 'Table_Last'GO

Following fig. Shows how we can change Table Name.

Now, the table name “Table_First” is renamed as “Table_Last”.

“Table_First” will no longer be available in database. We can verify this by running script:

USE AdventureWorks
GOSELECT *FROM Table_First
GO

The Messages shows an error “Invalid object name ‘Table_First’.”

To check that the new renamed table exist in database run script:

USE AdventureWorks
GOSELECT *FROM Table_Last
GO

Is this Page informative for you?? If Yes Please Pay your Donations to make this Blog as a website using below link

Donation Amounts

Option 1 $1.00 USD Option 2 $2.00 USD Option 3 $5.00 USD

 

Want to make some extra income??
Visit NeoBux

UK Visa Requirements for Non EU Nurses/Midwives

UK Visa Requirements for Non EU Nurses/Midwives

In order for Nurses and Midwives from non EU countries to take up employment in the UK they need to be registered with the UK Nursing and Midwifery Council (NMC); however in order to register with the NMC you will need to meet certain requirements.One of the requirements is you must have the following minimum education/training qualifications:

• It is important that you have been studying for at least three years or 4600 hours in length.

• Post secondary education is essential and you must have demonstrated theoretical and practical work

• Your instruction should not be less than one third theoretical training and not less than one half clinical/practical training.

• General and specialist medicine

• General and specialist surgery

• Child care and paediatrics

• Maternity care  

• Mental Health and Psychiatry

• Care of the elderly

• Home Nursing

There are a number of nursing and midwifery areas that you will be able to work within if you are successful with your registration to the UK Nursing and Midwifery Council (NMC). You may be able to get a firm offer of employment working within the NHS, private hospitals, private companies, GP surgeries, health screening clinics, care homes and learning disability homes.This theoretical and clinical/practical training must be within the following areas:If you are successful in your registration you will be given permission to enter the UK for a maximum of 18 months then you will be expected to leave once this period is over. You can come over to the UK on both a short and long term contract; however as well as the above restrictions you also need to have at least six months post registration experience and to come over to the UK to practise nursing or midwifery you need to have a firm offer of employment as well as a good grasp of the English language.When you are applying for your work permit/visa to come to the UK to practise nursing and midwifery your application should be processed within 135 days; however there is the possibility of delays so it is advised that you apply about six months in advance to ensure that you get your UK work permit/visa on time.If you require any additional help regarding coming to the UK to practise nursing/midwifery as a non EU resident then contact the team here at Immigration Consult.