locked
Delete row from MS SQL Server 2000 RRS feed

  • Question

  • 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?

    Sunday, July 1, 2007 5:16 PM

Answers

  • Hi

     

    Try to use this (and please read help Wink )

     

    delete from Student where [ID] = '0107200701'

     

    You should change the ID to your real ID

     

    Regards,

     

    Janos

    Sunday, July 1, 2007 7:06 PM