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 stored in the mssqlsystemresource database? : sql server database administration

0 Answers  

How do I view a stored procedure in sql server query?

0 Answers  

How do you start single user mode in clustered installations?

0 Answers  

Observed that some SP’s / Jobs are processing late, how to troubleshoot to improve performance?

1 Answers  

write down the code for "how we delete a table without using of Drop command " ?

7 Answers   CarrizalSoft Technologies, Sonata,

what is a schema in sql server 2005? : Sql server database administration

0 Answers  

Normalization and denormalization

3 Answers   Wipro,

What are the types of processing and explain each? : sql server analysis services, ssas

0 Answers  

What are the differences between DDL, DML and DCL in SQL?

0 Answers   ABB, Aspire, Infogain,

Differentiate between SQL and ORACLE joins and write their syntax.

0 Answers   Global Logic,

Mention the different types of replication in sql server.

0 Answers  

How optimize sql query with multiple joins in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories