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

Which data type can be used only on OUTPUT parameters of the stored proceduer?

2 Answers  

What are the authentication modes in sql server? How can it be changed?

0 Answers  

Can we use where clause in union?

0 Answers  

Can we do dml on views?

0 Answers  

How to use column default values in insert statements in ms sql server?

0 Answers  




What is collation sensitivity?

0 Answers  

What do you need to connect php to sql server?

0 Answers  

What is the purpose of indexing?

0 Answers  

What are orphan records?

0 Answers  

What is difference between views and stored procedures?

0 Answers  

what is a correlated sub-query? : Sql server database administration

0 Answers  

syntax and example for bitmap index in sql???

1 Answers  

For more SQL Server Interview Questions Click Here
Categories