Monday 2 July 2012

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
GO
SELECT *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
GO
SELECT *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
GO
SELECT *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
                                                        
 
Want to make some extra income??
Visit NeoBux

Wednesday 20 June 2012

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.

How To Optimize Your Blog For Search Engines



How To Optimize Your Blog For Search Engines

****************************************************
SEO is all about ways to get your website to the top of search engines known as optimize your blog for search engines. That helps you to increase your site traffic tremendously, By Choosing a right keywords for the content in blog increases your search engine ranking.
But How To choose a right keyword?
Focusing your content on keywords which is related to your topic + Content. Visitor hits your site when they Google the related Keyword of your content . Before, ensure that your content and topic’s keywords are searches mandatory of all ages. Have you noticed my first line with < h 1 > tag in this article? when people use Google to search any phase word in the above five line, this article will be automatically indexed by Google according to Page Rank (PR).

********************************************************************************

I bet no blogger gets a 1000 natural hits per day without having at least hundreds of content in their blog. Even me, When i started Elite fox blogging i wrote few articles and waiting for more then 1000 hits in first trial, Tee-hee. I know every beginners expects this when they started blogging. When you done posting maximum amount of rich content article, naturally you will get a flow of visitors – SEO.
Digg More: 20 Mistakes You Do When You Blog For First Time
Optimize your blog for search engines, and i’m here not to disappointment you for providing only basic information. Well, My point is “Do more backlinks, backlinks, backlinks and backlinks”. Accept backlinks from other websites which has legal content, it help your fellow blogger visit often. Make your website bigger and give away for an other bloggers to comment and be acknowledged your blog as web community too 
Too much of backlinks affects your Pagerank, So avoid Backlinks from website engaged with “BLACK HAT SEO”. approve genuine backlinks.
NB:
After reading this some beginners could try to change their content keywords, for my fellow blogger who intended to do, i would like to say don’t overdo the keywords. Over stuffing keywords will result in a poor search ranking for your website, Let it better be. Try this for your upcoming article and get better ranking in search engine optimization.
If you add “< h 1 >” tags in your content, keywords, description and paragraph, you have a high possibility to surpass high ranking content.




Google AdSense Approval Process


How to Get Adsense Approval Easily

How to Get Google Adsense Approval Easily in Quick Time. Step-by-step procedure to getadsense approval within 3 days.
It is very easy to get Google Adsense Approval even you are residing in India. You cannot wait for 6 months to get approval for your website. You can get adsense approval within 3 days maximum. But you have to follow Google Adsense Approval Process below strictly to get approval in quick time and in genuine way. I now explain you step-by-step you have to follow these steps correctly to get easy approval.
1.Register a Domain (Paid Domain not a free website or blog) You must be the owner of the domain. That domain consist of keywords. You have to register your domain name with extension of .com / .org / .net . Don't register domain name with your country extentions or any other extentions other than the above three. It is not only useful for Google Adsense Approval but also help a lot in SEO. If you select correct domain for your website that exactly or perfectly matches your content then your work is 50% done.
2. Your website must be professionally designed. (You can use Dreamwaiver or Ms-Frontpage or Photoshop) for this if you are not familiar with web design. Then you can give it this work to web-design companies.
3.Your website content not copied from other blogs or other websites. Don't copy any content from other websites. You cannot get approval. My sincere advice is write your own content. Your website must consist of atleast 20 to 25 pages of Quality, Unique content. You have to prepare content for your readers not for search engines remember this.
4.You have design your website according to Google Webmaster Guidelines. If you need any help don't hesitate to call me. I am ready to help you. Then you have to register your website with Google Analytics and Google Webmaster Tools. Submit Site Map of your website to Google for easy crawling. You have to access the source code of your website (i.e HTML Code of your website)
5.Then create one g-mail id exclusively for Google Adsense. Don't use this g-mail id for personal or business or Google Adwords use.
6.To join this Google Adsense Program you must be 18 years of age.
7.Your payee name must match the name of your Bank Account. Either it is Savings Bank Account or Current Account. You can register your business as payee name or use your own name as payee name.
8.You have to write your address correctly. No mistake in this address. Because once your account reaches 10 US dollars Google will send one PIN-NUMBER Card to your address to confirm your payee name and address. Then you have to login your Google Adsense Account enter this PIN number in the required box (in My Account Tab) and confirm you are the payee.
9.Another thing you have to select best web host for your website. Because you have to make sure your server or your website not facing Malware or Spyware or Trojan virus problems or slow-server response in future. So select the best web-host in the starting stage itself.
10.Optimize your website content SEO friendly to get most out of the Search Engines.
11.Use Title Tag, Meta Keywords, Meta Description and Feedburner tags correctly. Make sure all your HTML Codes properly closed.
Now we come to the Stage How to Fill Google Adsense Application Form1.First you have to fill the URL of your website like thishttp://www.yourname.com. Don't forget to put http:// before your website name. Otherwise, your website not accept by Google.
2.Website Content Language is always English. Don't select any language other than English for your website. This is my humble request to all my internet friends. You cannot get approval or you cannot get more visitors if your website is in other language. So prefer English as your language of the content.
3.Please Tick both boxes
I will not place ads on sites that includes incentives to click on ads.
I will not place ads on sites that includes pornographic content or illegal content.
4.Now choose Account type. Either you can choose Business Account or Your Personal account as your payee name.
5.Your Payee Name must match the account of your name in Bank Account.
6.Enter Door Name, Street Address, City, Country, Pin-codes, zip code correctly in appropriate boxes. While filling the Adsense Application form don't divert your attention, concentrate hard to fill the form. Because it is one time fill up form. You cannot going on changing the content of the form regularly unless and until you will get the approval. Once you get the approval you can change the address in My Account tab. Except Payee name you can change anything in the Adsense Application form.
7.Then enter your phone number, e-mail preference to receive occasional news letter and announcements from Google.
8.How did you find Google Adsense. For this you can always select friends and colleagues.
9.Then you have to accept the Adsense Program Policies set by Google.
10. Click the Submit button, if you have already g-mail account you can login with that account otherwise create a new g-mail account. That's all once you login. It shows with 1-2 days your website will be review and get approval.


Your comments are valuable for me, please place your comments here.



Alappuzha – Kerala’s Enchanted Water World


Alappuzha – Kerala’s Enchanted Water World


Alappuzha Kerala

Alappuzha -- the name means “broad river” in Malayalam -- is famous for its backwaters, houseboats, boat races, temples and seafood. These attractions have earned it the moniker “Venice of the East.” Founded in 1762 by Raja Keshavadasan, Diwan of the princely state of Travancore under Maharaja Raja Rama Varma, it is considered to be the oldest planned town in the region. This year Alappuzha, formerly known by its Anglicised name of Alleppey, celebrates its 250th anniversary. 


Vembanad Kayal between Alappuzha and Kottayam districts of Kerala is the largest backwater in Kerala and the area surrounding it is called ‘Kuttanad’. Its history dates back to the Tamil Sangam age (3rd century BC to 4th century AD). The early Cheras, who had their home in Kuttanad, were called ‘Kuttuvans’, taking their name after this place. One of the most powerful kings in the dynasty, Cheran Senkuttavan, is said to have ruled his vast kingdom covering Kuttanad.

Alappuzha Kerala


Early in the first decade of the 20th century, the then Viceroy Lord Curzon visited Alleppey, as it was then known to the British rulers. Impressed by the immense beauty of the place, he declared that this was indeed the “Venice of the East”. The resemblance between the two cities in landscape, port, criss-crossing roads and the bridges across them, and the scenic coast might have elicited this comparison.

Alappuzha Kerala

Alappuzha was once the lone supplier of coir products, coconuts, coconut oil, pepper, tea, rubber, cardamom to the world markets before the establishment of the Cochin Port. The development of Cochin harbour in the last century marked the decline of Alappuzha market and port. However, in the last three decades, Alappuzha has reinvented herself as the hub of backwater tourism in the state. Alappuzha is also the access point for the popular annual Nehru Trophy Boat Race, held on the Punnamada Lake, near Alappuzha.

Alappuzha Kerala


Alappuzha provides a unique canvas to the traveller, where life revolves around water. Here there are few roads; only waterways. Though roads have been constructed in the last two decades, some areas are so enclosed by water that they are navigable only by boat and ferry. Houseboat cruises operating in these backwaters connect Alappuzha with Kumarakom and Cochin in the north and Kollam (formerly Quilon) to the south.

Alappuzha Kerala

Alappuzha's allure is not merely in its backwaters, but in the small islands protected by mud walls and paddyfields covered with water throughout the year. Kuttanad, the rice bowl of Kerala, is one of the few places in the earth where agriculture is carried out four to ten feet below sea level. These areas showcase indigenous agricultural engineering and remind the visitor of the famous dikes of Holland.

Alappuzha Kerala

We started on our much awaited houseboat journey in the breezy backwaters of Alappuzha. The crew of three warmly greeted us with a welcome drink of fresh juice. Soon, lunch was served. We rested for an hour as the boat was moored and watched kingfishers and cormorants. The houseboat was docked and anchored for the night at around 5:30 PM, when we were served tea and snacks. The authentic Kerala-style lunch and dinner we were served were delicious both in quality and quantity. The menu consisted of rice, fish (karimeen), chicken, chapati and vegetarian dishes. The cook notes beforehand your preference for the type of rice – the brown-husked Kerala Matta boiled rice or other south/ north Indian varieties.

Alappuzha Kerala


A Kerala houseboat is about 60 to 100 feet long and around 12 to 18 feet wide in the middle. House boats have fully furnished single, double and triple air-conditioned bedrooms, an exquisite sundeck, comfortable chairs, classy kitchen and toilet. There are separate restrooms for the boat crew. Traditional lanterns are used as lights. Some boats are equipped with solar power. A leisurely ride on a houseboat or a small snakeboat is enough for you to rejuvenate your holiday. Sailing on the gentle water is a lifetime experience.

Alappuzha Kerala

You pass by vibrantly painted houses located just a few steps away from your boat, with colourful clothes drying on clotheslines. You pass close enough to hear the alarmed clucking of chickens in their coops and to see women wading in waist-deep paddy fields. Fishermen row towards your houseboat hoping to sell their catch of fresh fish and crabs, caught right before your eyes. On the banks, you can glimpse the occasional temple or church, and shops and hospitals with small boats parked in front of them.

It is a pleasure to escape the noise and pollution of urban life and listen to birdsong and the calls of children as they wave to your houseboat on their way to school. As evening sets in, young boys often sit at the edges of their homes, fishing for the evening meal. A famous saying goes about the children of Alappuzha: "Children learn to swim before they walk. They learn to row before they bicycle. They learn their first lessons from the school of fish.”

At sunset, the waters gleam with sunrays and take on a golden sheen. When the boats are docked for the night you can walk around the small villages and shops, meet the local people and see the traditional way of transportation in water.



Alappuzha Kerala

Alappuzha Kerala


Indescribable are the views of sunrises and sunsets from islands covered with coconut trees.

Alappuzha Kerala

The next morning, we rose early and watched the magical sunrise. Even before sunup, hundreds of birds made their way for an early breakfast, cutting through the sky in distinct flight patterns. Not surprisingly, Alappuzha is a paradise for birds and birdwatchers.

Alappuzha Kerala

Dawn announces a hard practice session for rowers, who are trained vigorously by the Sports Authority of India Water Sports Centre (Alappuzha), in preparation for the National Games. We could feel the fresh air around the waterways. A traditional Kerala breakfast was served and we prepared for our return trip.

Alappuzha Kerala


Mosquitoes bothered us at night although the boat had mosquito nets and repellents. Visitors are advised to carry mosquito repellent creams for additional protection. The smell of the backwaters can sometimes be disturbing. Sadly, some areas of Alappuzha were unclean and unsanitary as people disposed of garbage and human waste directly into the backwaters.

Alappuzha Kerala

Although Alappuzha is welcoming throughout the year, the best time for a visit is winter (temperatures range from 20°C to 32°C from October through March). The summer months (22°C to 35°C) are humid. The nearest airport is Kochi, located at a driving distance of 54 km (approximately 90 minutes). Malayalam is the most spoken language. Tamil, Hindi and English are also widely spoken.

Rates can go up heavily in the peak season. Advance booking is advised. Boats may be rented for Rs. 8000 – Rs.12000 (for 4 adults and 4 kids) all inclusive for a one day / night tour (check in 12:00 noon to checkout 09:00am the next day). Check the quality of the boats before you select the one you like. It is worth paying a little more for better quality and service.

Alappuzha Kerala

A wide selection of scenic routes is available for houseboat cruises. Choose one that suits your budget and schedule. Houseboats are mainly based at Alleppey and Kumarakom. A one-night cruise may be too short. Daily backwater tours – ranging from one hour to a full day – are also available.
Alappuzha Kerala

To enjoy the best experience of narrow canals, hire an environment-friendly, hand-pulled canoe, as none of the houseboats can enter the narrow canals. A journey to the hearts of the estuaries of Kerala is a memorable experience for any tourist. This, the land of swaying coconut trees, emerald waters and blue skies, is aptly named 'God's Own Country'.






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

                                                        Donation Amounts
                                                             
 
Want to make some extra income??
Visit NeoBux