SQL SERVER – Puzzle – Why Decimal is Rounded Up?

This not about type of Variable to which output will be assigned, its about the operand’s data type. in First example both are integer therefore output is integer and similarly in second, one of the operands is decimal so output is decimal.


Doxygen-> LaTeX -> PDF using MikTex : Automatic Project Documentation

  1. Install Doxygen from URL
    1. 32 bit: http://ftp.stack.nl/pub/users/dimitri/doxygen-1.8.8.windows.bin.zip
    2. 64 bit: http://ftp.stack.nl/pub/users/dimitri/doxygen-1.8.8.windows.x64.bin.zip
  2. Install MikTex from URL http://miktex.org/download
  3. Select working directory to save/select setting file
  4. Fill Project Name
  5. Select source code directory from where documentation has to be generated
  6. Specify designation directory, where LaTeX will be stored.
  7. Click on next, select all entities.
  8. Click on next, select LaTeX and as intermediate format for PDF. Select required output HTML, LaTeX and RTF etc. For PDF LaTeX is mandatory.
  9. Clicking on next will open screen for diagram generator. Use built in class generator.
  10. Clicking on next last screen will be displayed.
  11. Click on Run doxygen button.
  12. Some message can be displayed, try to ignore.
  13. Progress will be displayed, please wait till “*** Doxygen has finished” is displayed.
  14. Open the target directory, specified in 3.d.
  15. modify the refman.tex file as per desired format like Logo on First Page, New Line, New Page etc
  16. Double click on refman.tex file from target directory.
  17. This will open MikTex editor, select XeLaTex command and click on “Green Run” button.
  18. Progress is displayed in console output.
  19. Some messages about “default to ^^91” can be ignored by hitting Enter key.

If left blank, this will default to ^^91

1^^92 P\+P\+D\+: 1 = Consu…

This will generate a pdf names refman.pdf in the destination directory. Like following is the completion message.

Output written on refman.pdf (318 pages).

SyncTeX written on refman.synctex.gz.

Transcript written on refman.log.

  1. It’s a two time compile process. 2nd time Toc is generated. Step 16 needs to be followed two times.

DO’s and DON’Ts when typesetting a document

LaTeX and Miscellaneous

The following rules apply when using LaTeX2e…

  • In display math mode, use [ ... ] instead of $$ ... $$.

$$... $$ is simply obsolete.

  • Use textbf, textit instead of bf, it.

bf, it are obsolete font selection commands. Under New Font Selection Scheme (NFSS), they should be replaced with textbf, textit. One immediate difference is that {itbf blabla} will not generate the composite effect of italic shape and bold series, while textit{textbf{blabla}} indeed produces bold italic fonts.

  • Put a tilde before references or citations, e.g., Jie~cite{habit06}.

This prevents LaTeX from putting a line break between the word and the citation. Similar cases are: length~$l$, function~$f(x)$, etc.

  • Be cautious when changing the page margin and page layout.

Studies show that articles with approximately 66 characters per line are the most readable. Reading would become difficult if putting more and more…

View original post 383 more words

Conflicting extensions for PHP development have been detected: Visual Studio

So you want to dedug PHP within Visual Studio.

You went ahead and installed extension 1 PhpTools from downloaded msi “PhpTools.xxxx.msi” from visualstudiogallery.

And for complete the installation, you also installed extension 2(like I did) Vs.php from installer “php vsphp_en_xxxx_web_installer.exe downloaded from URL

Then Visual Studio throws up below exception.

Microsoft Visual Studio
Conflicting extensions for PHP development have been detected:
– VS.Php
Continuing using of Visual Studio may result in an unpredictible behaviour. To fix this issue, please uninstall conflicting extension above and restart Visual Studio.



Because both these extensions are not supported by Visual Studio at same time, as they are conflicting in nature.

Why conflicting?  Because both extensions extend same features of Visual Studio and studio is saying that configuration of extension 1 has been or may be overwritten by extension 2.

So we need to uninstall one of these to use another.

Setting up php on Windows to connect to Oracle

Good Article

Solutions to IT problems


I recently needed to setup a Windows-Apache-PHP Server that can connect to Oracle. It turned out, that this is not a straight forward task to do if you are not used to it.

Which Apache and PHP Version to use

The newest Windows PHP version is compiled with the VC9 compiler. The default apache version for windows from http://httpd.apache.org/ is compiled with the VC6 compiler or said otherwise: they are not compatible. The solution is to either get the apache version from http://www.apachelounge.com/download which is complied with VC9 or use a older PHP version compiled with VC6. The approach you choose probably depends  if a VC9 compiled version if the modules is available. I went with the older PHP version (5.2.17) and VC6. Always select the thread-safe PHP version if you are using apache php module.
For this php version, download the zip archive. The installer did not work correctly…

View original post 307 more words