December 02, 2012

We are moving to a newer site: rhub.in

Hello Readers,

Thanks for your following and reading. Now we are moving to a whole new site of our own. It is http://rhub.in. Hope to see you there too, with greater enthusiasm.

Keep reading.

November 23, 2012

View file names in two rows in Notepad++

Notepad++ is one of favorite tools of many programmers and script writers. Many a times we are in such a situation wherein we have to keep many files open at some common time. In such a situation, we have to rely on [Ctrl][Tab] or < and > arrow on the row of filename tabs in Notepad++.

Alternatively, we can have multiple rows of filenames in Notepad++. For this, we have to make this setting:
Settings -> Preferences -> General -> Tab bar -> Multiline

Ensure that 'Multiline' chekbox is checked. When it is checked, filenames are displayed in 1, 2, 3 or as many rows as required  for currently opened files, based on number of files and lengths of their names.

Enjoy coding this time!

October 22, 2012

"TABLE" keyword and SQL statements

We are many a times confused about whether TABLE keyword appears in a SQL statement. Here I present a handy trick. It says:

Read below sentences in sequence-
Beside others, there are two types of SQL statements- DDL and DML.
DDL deals with creating, altering and dropping data structures such as tables.
DML deals with inseting, updating and deleting data within tables.

As DDL deals with main furniture of database, i.e., tables (similar to wooden tables) and they can drop your tables (on the ground to destroy them), they expect use of TABLE word explicitly.
e.g.,
CREATE TABLE t1(...);
ALTER TABLE t1 ...;
DROP TABLE t1;

As DML deals with data within tables, they do not use the word TABLE. In DML statements, table name appears directly (without use of keyword TABLE).
e.g.,
INSERT INTO table01 ...; -- TABLE keyword not used here
UPDATE table01 ...; -- TABLE keyword not used here
DELETE FROM table01 ...; -- TABLE keyword not used here

The above find is my own. In the beginning, even I had also been confused with the use of TABLE keyword. But, as it is rightly said, "Need is the mother of Discovery," I have finally come out of this trauma.


[If you like posts, do share their links.]