Category: web development

Useful command of MSSQL Query when comparing and manipulating text data

Extract table from another table SELECT * FROM dbo.SFG_Event_21_22 except SELECT * FROM dbo.SFG_Event_21 Bulk insert BULK insert dbo.SFG_Event_21_22 from ‘C:\Users\joemac\Desktop\final.csv’ WITH ( firstrow = 1, fieldterminator = ‘,’, rowterminator = ‘0x0a’ ); GO bulk insert cannot understand text qualifier bulk insert add NULL for blank data by default Replace string value of a column… Continue reading Useful command of MSSQL Query when comparing and manipulating text data

Published
Categorised as DB

WordPress template selection for restaurant, Sep 2013

http://tasteofjapanwp.prospekt-solutions.com/ http://themelaboratory.com/showcase/mazzareli/wp/ http://demo.themovation.com/eatery/ http://www.themes.red-sun-design.com/lemonchili/ http://suitstheme.com/demo/verona/ http://alethemes.com/delizioso/  

OpenCart template selection for retail shop, Oct 2013

1. http://rgenesis.com/themeforest/RGen-OpenCart-Modern-Store-Design/demo8/ 2. http://321theme.com/sellya/ 3. http://bigturner.com/opencart/madame/demo2/ 4. http://journal.digital-atelier.com/4/ 5. http://oc.dedalx.com/simplegreat/simplegreat8/#

Quality coding with Visual Studio plug-ins

Utilising a few useful tools can make your code quite productive. Fix all “Warnings” Use FxCop Download here.  Install FxCop Runner extension, then you can run FxCop inside VS and see the warnings together with original VS warnings in warnings window. (It’s integrated as Code Analysis in VS2012, so you don’t need to install FxCop again) Use CodeMaid… Continue reading Quality coding with Visual Studio plug-ins