IS Ram Sethu is True ?

Are the ancient Hindu myths of a land bridge connecting India and Sri Lanka true? Scientific analysis suggests they are. #WhatonEarth pic.twitter.com/EKcoGzlEET

— Science Channel (@ScienceChannel) 11 December 2017

How to find duplicate records from sql server Table and Delete

How to find the duplicate record ?

Finding duplicate record from table using CTE.

WITH CTE
AS
(SELECT NAME,EMP_ID,ROW_NUMBER()
OVER(PARTITION BY NAME ORDER BY NAME)
AS NAMEDUP FROM EMPLOYEE)
SELECT * FROM CTE WHERE NAMEDUP > 1 ORDER BY NAME

Using Having Count

SELECT NAME,COUNT(NAME)FROM EMPLOYEE
GROUP BY NAME HAVING COUNT(*)>1

Using group by

SELECT NAME,COUNT(NAME) AS CNT
FROM EMPLOYEE
GROUP BY NAME

Deleting duplicate records from the table.

WITH CTE
AS
(SELECT NAME,EMP_ID,ROW_NUMBER()
OVER(PARTITION BY NAME ORDER BY NAME)
AS NAMEDUP FROM EMPLOYEE)
DELETE FROM CTE WHERE NAMEDUP > 1

How to set Sql Server Mode In IIS in ASP.NET ?

1.We need not to create a  new database We have a tool called aspnet_regsql.exe tool (Aspnet registersql).
This tool is present in c:\windows\Microsoft.net\framework64\version.
2.In the Run command window prompt we have to run below mentioned commands
A.In that mentionpath where the tool exists,Toolname -s Sqlservername -E(Means windowauthentication) -ssadd(Add support for SQL serve sessionmode -sstype p(MeansSession variables will store in ASP state sql server database)
3.Need to set mode to SQLserver
<sessionstate mode="SqlServer" sqlconnectionstring="datasource=.; userid="username" pwd="p***"/>

What are the Event Handlers that can be included in the Global.asax file ?

There total 5 events in global.aspx file
1. Application_start
 --- When ever first instance of HTTPApplication class created.
2.Application_Error:
-- When ever unhandled exception occurs in the Application
3.Application_End
--- When ever last instance HTTPApplication class destryoyed.
4.Session_Start :
 -- user visits the application.
5. Session_End :
   --- When the session state is set to inproc then this event gets fired.

how to find special characters in database tables in db2

Have to use TRANSLATE funtion to find the special characters data in db2.


ex :

SELECT COL1,COL2
FROM TABLENAME WHERE LENGTH(TRIM(TRANSLATE(COL3,'`!@#$%^&*()_-+=|\}]{[":;?/<,>.',' '))) IS NULL


SELECT COL1,COL2,COL3,TRIM(TRANSLATE(COL3,'`!@#$%^&*()_-+=|\}]{[":;?/<,>.',' '))
FROM TABLENAME

How to know built in functions in Python

How to know the built in functions in Python ?

To know built in functions in Python type dir(__builtins__) press enter you will get all built in functions.

if you want to know how the functions works use Help to know the functionality
like
help(pow) it will display the functionality of particular function

Secrets About Sabarimala in telugu

Secrets About Sabarimala in Telugu watch the video

International Yoga Day Special-Complete Yoga Training in Telugu

PathanjaliYoga

Pavanamukthasana

KatichakraAasan

ThadaAasan

Arthamatsyendrasan And Vakrasanam

Vajra Aasan


ChakraAasan

Sethubandhaasan

Supthavajraaasan


Dhanuraasan

Kapala-bathi

Padma-Aasana

salabhaAaasan

GomukhaAasanam

Hyper aadhi jabardasth back to back skits in one place.
Hyper Aadhi who worked as a software engineer now is working in jabardasth

Radha Movie Dialogues

Radha movie unit released movie dialogues on youtube.
Movie released today and running successfully with mixed reviews

How to identify fake rice and original rice

Here is the tricks and tips to identify the fake/plastic rice.Now days each and everything is duplicated with plastic and other. Eggs,Cabbage now rice,rice also manufacturing with plastic and mixing with original rice in many countries.
To identify the plastic rice
1.Pour the rice into bowl and fill with water plastic rice will float on water.
2. Boil the rice it will melt in hot water.
3.Take a little quantity of cooked rice into the bowl and keep aside for 2 to 3 days if the rice gets
   fungus it is the original rice if it doesn't gets fungus it is the plastic rice .

The Mummy Trailer released

The mummy trailer released after long time.Now it is trending in You tube.Trailer for our website viewers.
THE MUMMY

Prabhas Remuneration

Prabhas remuneration revealed today by cinema unit, as per film unit Prabhas getting huge remuneration compare to other Telugu film actors.previously he was getting 4 to 5 crores for the movie, but after bahubali, this remuneration changed to 5 to 50 crores.yes, now Prabhas has taken total 50 crores for bahubali 1 and 2.
Bahubali -20 crores
Bahubali -30 crores.

Diabetes Diet

The precautions to be taken to avoid it.
How to avoid Diabetes:
As we already said Diabetes is of 2 types.Type1 and Type2. Type 1 Diabetes cannot be avoided as it completely genetical. But there is chance to avoid/control Type 2 Diabetes.
• We can take risk assessment test from Doctors about Diabetes using few tests that are already available now
• Regular exercise is required. At least 4 days in a week we have to do some physical activities early morning like speed walk, jogging, running, playing sports etc. 30 to 45 min of exercise is needed daily. Also whenever time allows we have to use physical activities like walking on steps instead of lift etc. Regular moment of body is required at any time in a day.
• Food plays vital role in controlling or avoiding Diabetes. We have to reduce fat in our diet and stay away from processing foods and cool drinks. Natural and fresh vegetables and fruits need to be taken. Food should be taken in small amounts in regular intervals of time. Complete the dinner before 2 hours of sleep.



• Quit smoking and if you have habit of drinking just limit to 30ml per day only.
• Body weight should be maintained. BMI should be less than 25 only. ( BMI = Weight in kgs/ square of height in meters)
• Blood pressure should be controlled strictly.
• Visit doctor once in a year (if you are healthy currently) for complete body check-up. If you are already Diabetic complete body check-up should be done twice a year.
Diabetic chart:
If you are already diabetic then mostly the daily diet should be as follows
• 6 AM: Coffee/Tea (Sugarless)
• 8 AM: Idly (3) / Vada / Chapathi / Plain Dosa / Upma. Avoid coconut chutneys.
• 10:30 AM : Vegetable Salad with butter milk
• 12:30 PM (Lunch): 2 cups of rice, any leafy vegetable curry Dhal, Sambar, Rasam and butter milk. Limitedly chicken/fish. Curd needs to be avoided.
• 3 PM: Light snacks like salt biscuits and Tea (Sugarless)
• 6 PM: Butter milk or fresh vegetable juices. Avoid Fruit juices and cool drinks
• 8 PM (Dinner) : Same like Lunch
• 10 PM: Milk/Butter milk.
Diabetic Food:
Frequent food items that can be consumed regularly : All types of vegetables mostly Kheera, Bitter gourd, Tomatoes , Cabbage, onions, All types of leafy vegetables, Dhal, Sambar , Rasam, Lemon soda/juice, Butter milk , Tea/Coffee (Sugarless), Vegetable Juices , Chapathi, pure water
Foods that needs to be taken limitedly: Rice, Noodles, Bread, Corn, Milk/Curd which does not have cream, Meat, Fish, Eggs.
Fruits like Oranges, Guava, water melon, apples, Papaya, rose apple (neredu pallu), pomegranate
Foods need to be avoided: Sugar, Honey, Jaggery, Glucose, Jam, Ice creams, Cakes, Biscuits, chocolates, Ghee, Dalda, coconut oil in foods, fried curries, chips, all types of beets, coconut, pickles, badam, ground nuts etc
Meat types like prawns, crab, pig, liver, pulav.
Fruits like mangoes, banana, grapes, Kharjura, Custards and Jackfruit etc.
All types of fruit juices, cool drinks, coconut water, powders like Horlicks, viva, boost etc



Very limited amount of oil has to be used in regular cooking. Refined oil or sunflower oil or olive oil is good. Daily usage should not be more than 5 table spoons. Just 5 gms of salt needs to be taken in a day.
Stayed tuned for more tips on controlling Diabetes ……
Note: Once again we want to say that the above mentioned points are general and not same for each and every individual. Diabetic patients should consult Doctor on regular basis about the food/medicines/physical activities and then has to follow the same.

Meryl Streep powerful speech at the Golden Globes -2017

On the event of Golden globes-2017, A 67 years holly wood actress fired on donald trump.
She given power full speech about donald trump without using his name in her speech.

Sachin and zakir Hussain

A rare combination cricket legend sachin tendulkar and music mastreo tabla player zakir sharing thier experience in one stage.
interview will be happen these two legendries.
On jan 9 2017