SQL Server: Text to Ntext

How to change data type text to ntext that isn’t NULL (there are records)? Since there is no way you can’t modify it, here is the alternative. In this assumption ‘kolom’ is the name of column that have to be changed and table_name is the name of table. Here you go!

1. Rename column ‘kolom’ to ‘ren-kolom’, use this code,

sp_RENAME ‘table_name.kolom’, ‘ren_kolom’, ‘COLUMN’

2. Add column ‘kolom’ data type ntext, use this code,

ALTER TABLE table_name ADD kolom ntext

3. Copy field in column ren_kolom to kolom, use this code,

UPDATE table_name SET kolom = ren_kolom

4. Delete ren_kolom, use this code,

alter table table_name drop column ren_kolom

Walla.. it changed. 

MARRIAD IN BALI PART 2 - MEANING AND SYMBOL

Marriage Law no. 1 in 1974, its validity of a marriage is based on each religion law. So for Hindu believer, through ritual process so-called " Mekala-kalaan" ( natab banten), usually be puput by a pinandita. This ceremony performed in house yard ( middle of natah) because it is central point of strength " Kala Bhucari" as region power madyaning housing field. Makala-kalaan comes from word " kala" is meaning energy. Kala is manifestation of kama strength which having quality of giant ( asuri sampad), so that it can give influence to marriage couple which usualy called as " sebel kandel".

With ceremony mekala-kalaan as supporting facilities for neutralize ( nyomia) strength of kala having the character of negative in order to become kala hita or change to become quality of deity ( Daiwi Sampad). So by requesting blessing from Sang Hyang Kala Bhucari, nyomia Sang Hyang Kala Nareswari becomes Sang Hyang Semara Jaya and Sang Hyang Semara Ratih.

So ceremony mekala-kalaan means as authentication of marriage couple through hallowing process, at the same time sanctifies seed contained both couple, in the form of sukla ( spermatozoa) from the bridegroom and ( ovum) from the groom.

MARRIAGE AND BALI CASTE

Marriage of couple will not be confessed in Bali society otherwise they did traditional ceremony in trust of Hinduism and the couple will be excommunicated from their countryside.

There are three marriage styles in Bali:

" Ngerorod : Where men and woman arranges meeting somewhere according the vision of girl’s parent and spends the night together in house of a friend. In this situation, the girl is not allowed to return to her parent and stay, and curriculum vitae life is beforehand, but in most the girl’s parent is no wonder. They make exhibition either pretend to get restless of the naughty of the boy and his family for their daughter.

" Memadik : Form of marriage in Bali which the parent and member of family of the boy comes to the girl’s parent house and with respect asks their daughter.

" Nyentana : Marriage system in Bali which the boy go to the girl house and thereafter belong to the girl’s family.

After usul or escapee, a priest does simple ceremony to call mekala-kalaan, it is look like marriage of small civil in west world. The couple use traditional clothes of Bali so that they have been married legally.

The boy in general has reception for friends which is not invited until traditional ceremony been held. Three days after marriage procession, the family visit the son of girl’s family, in its house, the ceremony of ketipat bantal is done. Mantras sung and devoting given to clean sperm and egg in hoping both of them would free of badness influence and devil will not bother in embryo forming. Last years ago, system of marriage in Bali is very strick. Only couple from the same caste may married, to look after purity of caste system. In this era now, caste system shall no longer hold still be such about flexibility of bali and more excrutiatingly is permitted.

to be continued...

A Lion and a Mouse

A lion was awakened from sleep by a mouse running over his face. Rising up angrily, he caught him and was about to kill him when the mouse piteously entreated, saying, “if you would only spare my life, I would be sure to repay your kindness.”

The lion laughed and let him go. It happened shortly after this that the lion was caught by some hunters, who bound him with strops to the ground. The mouse, recognizing his roar, came gnawed the rope with his teeth, and set him free, exclaiming.

“you ridiculed the idea of my ever being able to help you, expecting to receive from me any repayment of your favor; now you know that it is possible for even a mouse to confer benefits on a big lion.”