You can use the sp_MSforeachtable stored procedure like so: USE MyDatabase EXEC sp_MSforeachtable ‘TRUNCATE TABLE ?’ Be warned that this will delete (by truncation) ALL data from all user tables. And in case you can’t TRUNCATE due to foreign keys etc. you can run the same as a delete: USE MyDatabase EXEC sp_MSforeachtable ‘DELETE FROM … Read more
There doesn’t appear to be a way to make it automatic, but you can use the .width command to manually specify the column widths. See here (search the section for .width).
In more recent terms as of Gremlin 2.3.0, removal of all vertices would be best accomplished with: g.V.remove() UPDATE: For version Gremlin 3.x you would use drop(): gremlin> graph = TinkerFactory.createModern() ==>tinkergraph[vertices:6 edges:6] gremlin> g = graph.traversal() ==>graphtraversalsource[tinkergraph[vertices:6 edges:6], standard] gremlin> g.V().drop().iterate() gremlin> graph ==>tinkergraph[vertices:0 edges:0] Note that drop() does not automatically iterate the Traversal … Read more
You can use Math.Round: decimal rounded = Math.Round(2.22939393, 3); //Returns 2.229 Or you can use ToString with the N3 numeric format. string roundedNumber = number.ToString(“N3”); EDIT: Since you don’t want rounding, you can easily use Math.Truncate: Math.Truncate(2.22977777 * 1000) / 1000; //Returns 2.229
According to OpenGroup: O_TRUNC If the file exists and is a regular file, and the file is successfully opened O_RDWR or O_WRONLY, its length is truncated to 0 and the mode and owner are unchanged. It will have no effect on FIFO special files or terminal device files. Its effect on other file types is … Read more
There is no build-in math.round() function in Lua, but you can do the following: print(math.floor(a+0.5)).
According to the ISO C standard, when you convert an integer to a signed type, and the value is outside the range of the target type, the result is implementation-defined. (Or an implementation-defined signal can be raised, but I don’t know of any compilers that do this.) In practice, the most common behavior is that … Read more
http://dev.mysql.com/doc/refman/5.1/en/truncate-table.html According to this URL, as of MySQL 5.1.32, TRUNCATE TABLE is DDL and NOT DML like DELETE. This means that TRUNCATE TABLE will cause an implicit COMMIT in the middle of a transaction block. So, use DELETE FROM on a table you need to empty instead of TRUNCATE TABLE. Even DELETE FROM tblname; can … Read more
I actually wrote a solution for this on a recent project of mine. I’ve compressed the majority of it down to be a little smaller. def smart_truncate(content, length=100, suffix=’…’): if len(content) <= length: return content else: return ‘ ‘.join(content[:length+1].split(‘ ‘)[0:-1]) + suffix What happens is the if-statement checks if your content is already less than … Read more
If it’s for a single line try this: android:ellipsize=”end” android:maxLines=”1″ android:scrollHorizontally=”true” android:singleLine=”true” It worked for me.