If, I have to insert 4 records or more then i will write 4 insert queries to save records.
Like below screen.

And result will be 1 rows effected for each query.
We can avoid using multiple statements like as below in single statement.

Here we can use single statement and output is 4 rows effected.
I have shared the things which I have found new to me and will be helpful to others.
Thanks

Khargesh RajputPosted Mar 2, 2015, 11:15 PM
thanks
Viraj DeshmukhPosted Mar 2, 2015, 12:06 PM
Nice....