Import CSV into MSSQL database
This is really common task in any database project. You always need to get initial data into database. Maybe most common file format is CSV. We have CSV file in…
Read moreDeveloping with the Commerce Server Catalog System
I want to share two documents about Commerce Server and how to get data from it via API. This is only few information taken from MSDN and another internet sources.…
Read moreOptimised way how to get country by IP
Some time ago I was developing project what reports all action of user on web site. I hit big number of problems, mainly performance problem. Biggest site had around 40,000…
Read moreExecute dynamic SQL in MSSQL
I hit this need when I was developing own custom module into Commerce Server. Commerce Server have all tables separated into catalogs. Catalog is group of tables which contains records for particular client (site), but have same structure like all other catalogs. Lets say that we have two clients ‘Client1’, ‘Client2’. Each client has tables for products ‘Client1_Products’, ‘Client2_Products’. Now we can create two procedures for retrieving data from both tables or better we can create one procedure, which will have one input parameter – Catalog name.
Read morePower Toys for Visual Studio
‘Ok. Who changed this part!? Who can I blame?’ Some time ago I was looking for possibility to have functionality similar to ‘Blame’ – in Subversion – into Visual Studio…
Read more