Top "Truncate" questions

Truncating all tables in a Postgres database

I regularly need to delete all the data from my PostgreSQL database before a rebuild. How would I do this …

postgresql plpgsql dynamic-sql truncate database-table

I got error "The DELETE statement conflicted with the REFERENCE constraint"

I tried to truncate a table with foreign keys and got the message: "Cannot truncate table because it is being …

c# sql truncate sql-delete

Truncating long strings with CSS: feasible yet?

Is there any good way of truncating text with plain HTML and CSS, so that dynamic content can fit in …

css text layout cross-browser truncate

Limiting double to 3 decimal places

This i what I am trying to achieve: If a double has more than 3 decimal places, I want to truncate …

c# double truncate

Truncate with condition

truncate ->this resets the entire table, is there a way via truncate to reset particular records/check conditions. …

sql mysql truncate

Scala Doubles, and Precision

Is there a function that can truncate or round a Double? At one point in my code I would like …

scala double truncate rounding

I want to truncate a text or line with ellipsis using JavaScript

I'm looking for a simple script which can truncate a string with ellipsis (...) I want to truncate something like 'this …

javascript string truncate

SQL TRUNCATE DATABASE ? How to TRUNCATE ALL TABLES

I use SQL server 2008 R2. Is there a SQL command to empty the database, instead of having to truncate all 20 …

database sql-server-2008 truncate

Truncating Text in PHP?

I'm trying to truncate some text in PHP and have stumbled across this method (http://theodin.co.uk/blog/development/…

php truncate

Truncate Decimal number not Round Off

Possible Duplicate: c# - How do I round a decimal value to 2 decimal places (for output on a page) I …

.net floating-point truncate