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 / elumalai.k
delete from tablename where columnname=datatype
examples:
delete from employee where employeeid=2
| Is This Answer Correct ? | 13 Yes | 71 No |
Post New Answer View All Answers
Which joins are sql server default?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
Where do we use trace frag?
Write a sql query to get zero records from a table having n number of records?
What will be the maximum number of indexes per table?
What is the use of keyword with encryption. Create a store procedure with encryption?
What is in place upgrade in sql server?
What is factless fact table? : sql server analysis services, ssas
How do you create a data source?
Is it ok to shrink transaction log?
What is acid properties?
Mention what are the different types of ssrs reports?
What happens if the update subquery returns multiple rows in ms sql server?
What is a non-clustered index?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?