Tuesday, July 08, 2014

Find column exists in SQL database (COL_LENGTH)

COL_LENGTH

It is a built in function, which returns the length in bytes of the column.

COL_LENGTH('Table_Name','Column_Name')

Table_Name: Name of the table for which column length info required, it is nvarchar type expression.
Column_Name: Name of the column who's length is required, it is also nvarchar type expression.

It returns NULL on error or if users do not have permission to view object.

Wednesday, July 02, 2014

Bramhakamal (Orchid Cactus)

Hi Dear all,

Near to my home (in Bangalore) I have captured the growth of Bramhakamal flower growth, please have a look, snaps are here with little information for you all....
Early Stage - Bud
It belongs to Cactacease. Also known as Night Blooming Cereus, Queen of the Night or Lady of the Night, it is beautiful lotus like flower.


For planting, you can cut the stem / leaf and plant in the soil which has acidic features, or you can put the stem / leaf in water for around 3 weeks, after 3 week it will produce roots and then you can plant it in soil.











This flower bloom only for a night, blooming will start around 1900 hours and after 2 hours it blooms fully, early in the morning it drops.










Flower




Nice use by Mother for worshiping