Posts

Showing posts from January, 2020

Amazon web scrapping using PHP

Image
Welcome folks, as we know that amazon is the leading e-commerce company over the entire web, and it is still growing.      Now a day peoples also using amazon's different services to make their profits. There are a lots of ways to become a part of it. Becoming merchant, web scrapping affiliate marketing are some of those.   In this blog post i am going to show you how you can use PHP to get the latest current price of product listed on amazon. Now question arises that what is the benifits to know the latest pricing of products.   Lets me explain this point, on web you may create you own website to comparing the product price site, even you can create your own e-commerce website to sell the products and forget about price up and down (your scrapper will do this for you).  Of course you have to manage the packaging and delivery services on your own. Since, on web people mostly attracts on price so keeping the price up to date is a matter of loosing or g...

SCOPE_IDENTITY() Vs @@ Identity Vs IDENT_CURRENT(tableName) in Sql Server

Image
Hi there, in this blog post i am going to discuss the basic differences between SCOPE_IDENTITY(), @@Identity and IDENT_CURRENT('tableName').                 Basically all these three are used to retrieve the last inserted identity value in different session and  different scope. Let's try to understand it in detail. SCOPE_IDENTITY() :   It returns the value of identity last inserted within same session and same scope. @@Identity : It is a global variable which returns the value of identity last inserted within same session but in any scope. IDENT_CURRENT('tableName') : It returns the value of identity last inserted in any session and in any scope. Now, i am pretty sure you are wondering about what this session and scope really menu in the above mentioned points.   So, let me clear the same with an example. First we need to create two different but simple table with having the following structure. create table ta...