How to delete particular value in the column of a table.Is
it possible or not?if possible give it as in query.
Answer Posted / nilesh
Update tablename set Column_name = '' where f_name = 'student'
| Is This Answer Correct ? | 17 Yes | 7 No |
Post New Answer View All Answers
How to loop through the result set with @@fetch_status?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
explain extended properties
How do I find sql server instance name?
Explain having clause?
What can be used instead of trigger?
what is a schema in sql server 2005? : Sql server database administration
Can we write trigger for view?
How to write a query with a full outer join in ms sql server?
What is the use of commit?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
How many primary keys are possible in a table?
What happens if null values are involved in boolean operations?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
What is the difference between Normalization and De-normalization?