Interested to Buy Any Domain ? << Click Here >> for more details...
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
- - - -
- - - -
- 2 Answers
- 4415 Views
- I also Faced
- E-Mail Answers
Answer Posted / praveen ch
You want remove the records from table, just execute this query
truncate table [TableName]
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What do you understand by replication in sql server?
Difference between aggregate functions of sql?
What program is used to store the data source file?
Which joins are sql server default?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
How to assign new column names in a view?
What are the features of Embedded SQL
What is policy management?
what is an index? : Sql server database administration
What are the different types of upgrades that can be performed in sql server?
What is temporal table?
What are date and time data types in ms sql server?
What is sql server database?
What is etl - extraction, transformation, and loading?
Explain DBCC?
