Example: Delete from STUDENTDETAILS where StudentID = 101

How to delete particular value in the column of a table.Is
it possible or not?if possible give it as in query.

Question Posted / suresh.s

Answer Posted / suresh.s

Example:
Delete from STUDENTDETAILS where StudentID = 101

Is This Answer Correct ?

20 Yes

82 No

Please Help Members By Posting Answers For Below Questions

Give an example of why you would want to denormalize a database

990

How to backup encryption key ?

185

Why truncate is ddl?

1098

Can you create a logon trigger in sql server 2005 express edition?

1087

What is the difference between the 2 operating modes of database mirroring?

1126

How to include date and time values in sql statements?

1099

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

981

what is an extended stored procedure? : Sql server database administration

1071

Can we join two tables without primary key?

1065

Is sql server is free?

987

How to retrieve error messages using odbc_errormsg()?

1070

What is transact-sql language?

1106

Explain left outer join and right outer join?

1048

How does using a separate hard drive for several database objects improves performance right away?

946

What is difference between order by and group by?

1019