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

Is INSTEAD OF trigger directly applicable to Table ?

1064

What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

1200

Explain something about security and SQL Azure?

134

What happens if null values are involved in arithmetic operations?

1044

What is a select query statement in ms sql server?

1127

How to test values returned by a subquery with the in operator?

1250

What is analysis service repository?

1068

What is policy based management (pbm)? : sql server database administration

1029

What is built-in function?

1055

How self join is different from outer join?

1174

What are the types of stored procedures in an sql server?

1031

What is a partition function in sql server?

1215

What are pessimistic lock and optimistic lock?

1138

How to convert a table data in XML format in sql server?

2594

Why truncate is ddl?

1133