ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
How to delete particular value in the column of a table.Is 
it possible or not?if possible give it as in query.
 Question Submitted By :: Vanitha.s
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.
Answer
# 1		 
Example:
Delete from STUDENTDETAILS where StudentID = 101
 
Is This Answer Correct ?    0 Yes 7 No
Suresh.s
 
  Re: How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.
Answer
# 2		 
delete from tablename where columnname=datatype
examples:
           delete from employee where employeeid=2
 
Is This Answer Correct ?    0 Yes 6 No
Elumalai.k
 
 
 
  Re: How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.
Answer
# 3		 
You can not exactly delete the column value.
alternatively what you can do is use update statment and
update the value with blank.

update users
set user_adr = ''
where user_id = 'userid'
 
Is This Answer Correct ?    2 Yes 1 No
Rupa Bagherwal
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
Plz tell about backup&recovery?  2
1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks  2
What are the steps you will take, if you are tasked with securing an SQL Server? HCL1
How do we return a record set from a Stored Procedure in SQl server 2000?  2
how to rename the table  1
1.What is the deferece between DBMS & RDBMS? 2.How can you trouble shoot? If u will get error while installing sql server? 3.How can u trouble shoot slow running query? 4.how can u trouble log shipping errors? 5.why do we use merge replication instead of T.log replication? Microsoft4
What is the difference between DTS and SSIS? Allianz1
Different Types of Functions ? Satyam2
Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?  2
wht's the differece between sqlserver05 and sqlserver2000  3
How the data stores in a page?  1
internal language used in sql server 2000?  1
could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh  3
What all db objects can be found in MSDB database of a SQL Server instance? Accenture1
WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN SQL SERVER?  5
What is Deadlock? Satyam2
Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply Covansys1
How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.  3
i want to join two queries....and i want to run them as one after another that is want output of first query then second , then again output of first query then second and so on...  1
how to know Who Is Blocking Your SQL Server?  2
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com