Top "Truncate" questions

How to efficiently delete rows while NOT using Truncate Table in a 500,000+ rows table

Let's say we have table Sales with 30 columns and 500,000 rows. I would like to delete 400,000 in the table (those where "…

sql sql-server-2008 tsql sql-delete truncate

Pros & Cons of TRUNCATE vs DELETE FROM

Could someone give me a quick overview of the pros and cons of using the following two statements: TRUNCATE TABLE …

sql-server sql-server-2008 tsql sql-delete truncate

Truncate float numbers with PHP

When a float number needs to be truncated to a certain digit after the floating point, it turns out that …

php floating-point truncate floating-accuracy

Truncate string on whole words in .NET C#

I am trying to truncate some long text in C#, but I don't want my string to be cut off …

c# .net string truncate

Truncated Data when Importing from Excel to an Access Memo Field

Access is truncating the data in a couple Memo fields when I am appending an Excel file. The field in …

excel ms-access truncate truncation

SQL Server silently truncates varchar's in stored procedures

According to this forum discussion, SQL Server (I'm using 2005 but I gather this also applies to 2000 and 2008) silently truncates any …

sql sql-server stored-procedures truncate truncation

Using hibernate/hql to truncate a table?

What is the recommended way to truncate a table using hibernate/hql? I've tried this: Query query = session.createQuery("truncate …

hibernate hql truncate

How to open (read-write) or create a file with truncation allowed?

I want to: open a file in read-write mode if it exists; create it if it doesn't exist; be able …

python ruby truncate

How to truncate all user tables?

How can I truncate all user table in oracle? I have problem with tables constraints.

oracle constraints truncate

truncate string from a certain character in R

I have a list of strings in R which looks like: WDN.TO WDR.N WDS.AX WEC.AX WEC.…

string r truncate