How to go Moula Ali -Hyderabad, Telangana.

All Govt Jobs Examinations Conducting in Moula Ali Examination center Near Coca cola Company in Hyderabad.
here is the information to reach Examination centre.

Train: Three to Four Railway stations are there to reach Moula Ali.

1. Secunderabad Jn- After getting down in Secunderabad Jn. Have to travel using RTC buses to reach Moula Ali(Bus No-16,17)[Blue C cafe Opp Busstop]
Private transportation also available (auto fares are not more than 200).you can use Metro rail also to reach Moula Ali(Secunderabad-Taranaka) from Tarnaka have take autos or buses to reach Moula ali.

2.Moula Ali Railway Station: Have to Use Travel Apps(like ola,Uber etc),No RTC buses. Autos available in between 6 Am to 6 Pm, very less chance to get autos in the nights, means after 7 pm.
Note: Food and Hotels are not available at Moula Ali railway station. Have to walk(2kms) or auto to get food.
Lodges are available in Ecil and Tarnaka.
3.Kachiguda Railway Station: RTC buses available from near Kachiguda railway station, Have to walk less than half a kilometer to get buses.

4.Malkjgiri Railway Station: Auto s available from Malkajgiri for buses have to walk less than half a kilometer to get buses.

Bus : MGBS,JBS(RTC bus stops),IF private travels have to get down Ecil or Tarnaka from there you can get buses autos to reach moula ali examination centre.

If you want to stay in the nights Ecil or Tarnaka is best places.

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***"/>