go to enterprise manager inthat u can create ur own user name and password by that user name and pwd will help u to access query analyzer

give ur systemname as username and pwd as sa

do mean changing one column datatype format to antoher datatype format then alter table tablename alter column columnname newdatatype example: sno is int then changing int to float alter table student alter column sno float

any one i what that means the table that can have duplicate rows or particular rows.i already mension i can't give any constraints .

it can't deleting it only selecting. for select we are also select select DISTINCT * from tablename i need for deleting not for selecting kishore

[Message Deleted]

how can we delete duplicate rows when we are not using constraints usings query only kishore kumar.B