ronglianyang.wordpress.com

Getting Yesterdays or Tomorrows Day With Bash Shell Date Command | Curiosity

https://ronglianyang.wordpress.com/2014/01/15/getting-yesterdays-or-tomorrows-day-with-bash-shell-date-command

Skip to primary content. Getting Yesterdays or Tomorrows Day With Bash Shell Date Command. January 15, 2014. To display yesterday’s date, enter:. Date - date="1 days ago". Date - date="1 day ago". Date - date="-1 day". Tue Jun 14 04:54:40 IST 2011. This entry was posted in Uncategorized. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). You are commenting using your WordPress.com account. ( Log Out.

ronglianyang | Curiosity

https://ronglianyang.wordpress.com/author/ronglianyang

Skip to primary content. Skip to secondary content. Postgres vs SQL Server. March 6, 2014. Came across an article listing 10 points postgres wins. Getting Yesterdays or Tomorrows Day With Bash Shell Date Command. January 15, 2014. To display yesterday’s date, enter:. Date - date="1 days ago". Date - date="1 day ago". Date - date="-1 day". Tue Jun 14 04:54:40 IST 2011. October 30, 2013. Add dependency in pom.xml to use the class in other projects. How to count number of rows in a table efficiently? The fi...

BULK insert into a table with identity | Curiosity

https://ronglianyang.wordpress.com/2013/10/10/bulk-insert-into-a-table-with-identity

Skip to primary content. BULK insert into a table with identity. October 10, 2013. Use a view (which selects all the columns from the underlying table except the identity), and load into the view. Whether the identity corresponds to the file natural order is not sure, need test. This entry was posted in Uncategorized. And tagged BULK Insert. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public).

how to count number of rows in a table efficiently? | Curiosity

https://ronglianyang.wordpress.com/2013/10/16/how-to-count-number-of-rows-in-a-table-efficiently

Skip to primary content. How to count number of rows in a table efficiently? October 16, 2013. SQL Server has count function. When use count(*), it will return the number of all rows (NULL and NOT NULL), give you the exact number of rows for the table. the drawback is that it actually scans the whole table (columns and rows), so when the underlying table is huge (millions of trillions of rows), count(*) will take up a lot of resources. Then how to count efficiently? This entry was posted in Uncategorized.

Writing Shell Script | Curiosity

https://ronglianyang.wordpress.com/2013/10/08/writing-shell-script

Skip to primary content. October 8, 2013. The first line of the script is important. This is a special clue, called a shebang. Given to the shell indicating what program is used to interpret the script. In this case, it is. Other scripting languages such as. Perl, awk, tcl, Tk,. Also use this mechanism. # My first script. The second line is a comment. Chmod 755 hello world. Hello world http:/ www.cyberciti.biz/tips/find-out-if-file-exists-with-conditional-expressions.html. Leave a Reply Cancel reply.