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 are wait types?

0 Answers  

Why main is user defined function?

0 Answers  

What is difference between unique and primary key?

0 Answers  

What are the steps to take to improve performance of a poor performing query? : sql server database administration

0 Answers  

how to change column into row in sql

4 Answers   ESS,

How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?

1 Answers  

How to verify a login name with sqlcmd tool?

0 Answers  

How many jobs will create for Mirroring, Log Shipping, and Transactional Replication?

4 Answers   IBM,

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

0 Answers  

A left outer join B B right outer join A gives the same result then what is the use of two?

1 Answers  

can you instantiate a com object by using t-sql? : Sql server database administration

0 Answers  

What is a scheduled job or what is a scheduled task?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories