truncate Archives - IT Nursery

postgresql, Programming

IT Nursery

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

CSS, Programming

IT Nursery

Is there any good way of truncating text with plain HTML and CSS, so that dynamic content can fit in a fixed-width-and-height layout? ...

Programming, sql-server

IT Nursery

I need to empty an LDF file before sending to a colleague. How do I force SQL Server to truncate the log? 7 ...

For example, I might want to: tail -f logfile | grep org.springframework | <command to remove first N characters> I was thinking that ...

What’s the best way to truncate a datetime value (as to remove hours minutes and seconds) in SQL Server 2008? For example: declare ...

What’s the difference between TRUNCATE and DELETE in SQL? If your answer is platform specific, please indicate that. 32 Answers 32 Here’s a ...

I have a file, foo.txt, containing the following lines: a b c I want a simple command that results in the contents of ...

I would like to truncate a string such that its length is not longer than a given value. I am writing to a ...

Using MSSQL2005, can I truncate a table with a foreign key constraint if I first truncate the child table (the table with the ...

Why doesn’t a TRUNCATE on mygroup work? Even though I have ON DELETE CASCADE SET I get: ERROR 1701 (42000): Cannot truncate a ...