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

I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?

2 Answers   Techno Labs,

What is raid? : SQL Server Architecture

0 Answers  

How many null values we can have in a unique key field in sql server?

0 Answers  

What is public role in sql server?

0 Answers  

How can I create a new template for import ? : sql server management studio

0 Answers  

What is the usage of the sign function?

0 Answers  

What is cdc in sql server?

0 Answers  

Some queries related to SQL

0 Answers   Motorola,

Explain the dbcc pintable command when would you use it?

0 Answers  

Can you name a few encryption mechanisms in sql server?

0 Answers  

What is the name of the Database which IBM mainframe uses?

0 Answers   Wipro,

How do I find the transaction log size in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories