Here’s a list of differences. I’ve highlighted Oracle-specific features, and hopefully the community can add in other vendors’ specific difference also. Differences that are common to most vendors can go directly below the headings, with differences highlighted below. General Overview If you want to quickly delete all of the rows from a table, and you’re … Read more
There isn’t a Truncate() method on string, unfortunately. You have to write this kind of logic yourself. What you can do, however, is wrap this in an extension method so you don’t have to duplicate it everywhere: public static class StringExt { public static string Truncate(this string value, int maxLength) { if (string.IsNullOrEmpty(value)) return value; … Read more
DELETE FROM TABLENAME DBCC CHECKIDENT (‘DATABASENAME.dbo.TABLENAME’, RESEED, 0) Note that this isn’t probably what you’d want if you have millions+ of records, as it’s very slow.
Yes you can: SET FOREIGN_KEY_CHECKS = 0; TRUNCATE table1; TRUNCATE table2; SET FOREIGN_KEY_CHECKS = 1; With these statements, you risk letting in rows into your tables that do not adhere to the FOREIGN KEY constraints.
Contrary to the question asked, rtrim() will remove any number of characters, listed in the second argument, from the end of the string. In case you expect just a single comma, the following code would do: $newarraynama = rtrim($arraynama, “,”); But in my case I had 2 characters, a comma and a space, so I … Read more