Hi, I'm using SQL Server 2000 Personal Edition. I have created a table 'Student' which has 2 fields.
ID -- Varchar(10), Primary Key - contains ID of a student
NAME -- Varchar(50) -- contains names of student
ID NAME
0107200701 abcd
0107200702 cdgdh
0107200703 iyiylklk
.
.
I want to delete a complete row (all entries) from the "student" table using/specifing 'ID'. What will be the SQL query for that?
Hi
Try to use this (and please read help 
delete from Student where [ID] = '0107200701'
You should change the ID to your real ID
Regards,
Janos
