Day

April 22, 2009

Insert multiple record into table

In SQL, basically there are two ways to Insert data into a table; one is insert it one row per time, another way is insert multiple rows at a times. For the first method (insert one row per time) is the most common way to insert data into database that…

Get the number of row in database table

Normally to get the number of row for a particular table, where we will do is as the following query: select count(*) from Table_name Yes, you may get your result very fast if your table is very small, but if your table is more then 100k rows, then you may…