Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

what is an sql server?

1 Answers  

To which devices can a backup be created and where should these devices be located? : sql server management studio

0 Answers  

can any one please send sql quries most used in applications.

2 Answers  

Describe about first three Normal forms.

1 Answers   HP,

What is the diff between Dynamic queries and static queries

1 Answers   CGG, ICS Integrated Computer Solutions,

What is the use of MOVE keyword in restore command

3 Answers   IBM,

What is a non clustered primary key?

0 Answers  

What is mean by dml?

0 Answers  

What is the definition for sql server 2000?

0 Answers  

What is Cross Join and in which scenario do we use Cross Join?

0 Answers   QuestPond,

What is acid mean in sql server?

0 Answers  

could u plz explain about joins and views?

2 Answers  

For more SQL Server Interview Questions Click Here
Categories