1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

can any one post me,
how to remove rows in the below table
ENO ENAME EDEPT ELOC
3368 BPS BI Adayar
3371 RAN BI valachari
3369 SRI BI valachari
3372 jay BI Chn
- - - -
- - - -

Question Posted / hellowbanu

Answers were Sorted based on User's Feedback



can any one post me, how to remove rows in the below table ENO ENAME EDEPT ELOC 3368 BPS BI Aday..

Answer / praveen ch

You want remove the records from table, just execute this query

truncate table [TableName]

Is This Answer Correct ?    3 Yes 0 No

can any one post me, how to remove rows in the below table ENO ENAME EDEPT ELOC 3368 BPS BI Aday..

Answer / vandana chand

just simply type the following syntax:
DELETE from TableName.

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More SQL Server Interview Questions

 Explain what is sql override for a source taLle in a mapping?

0 Answers   Informatica,

What is sql server locking?

0 Answers  

can you any body tell me suppose database is suspect mode. how can take to normal?

2 Answers   Teledata,

How optimize sql query with multiple joins in sql server?

0 Answers  

Explain what is log shipping?

0 Answers  




How do I delete a sql server database?

0 Answers  

About DTS usage ?

2 Answers   Cognizant, Wipro,

How do I port a number to sql server?

0 Answers  

Can we perform backup restore operation on tempdb? : sql server database administration

0 Answers  

Ek lifafa 10 noto se bhara hai usme 2 or 5 ke note nahi hai aur usme total 50Rs hai, to batao lifafe me kon se not kitne hia it’s a challenge thank’s

6 Answers   Broadridge,

Why are sql functions used?

0 Answers  

How to genrate automaticlly empid like gt001

4 Answers  

For more SQL Server Interview Questions Click Here
Categories