• String comparison in sql server with case sensitive
    No Comments

    String comparison in Microsoft SQL server is case insensitive by default. So if you want to perform string comparison in SQL server with case sensitive, you have two choices. Consider the following scenario. You have Credentials table with UserName and Password columns.

    Read more
  • Singleton class in C sharp
    No Comments

    If you want a class that has only one instance for the entire application then you can create singleton class using following way. Create a class with a puplic static member which returns the same class instance. You need to use that member to access other members in that class. The following example code code…

    Read more
  • Windowless ActiveX controls are not supported
    No Comments

    In windows 7 environment you may receive “Unable to get window handle, Windowless ActiveX controls are not supported..” exception when you display a child form that contains ActiveX user controls. The user control may be a third party control. To avoid this exception you may disable DEP (Data Execution Prevention) for your activex control. DEP…

    Read more
  • Function to return table from delimited string
    No Comments

    In some scenario, you may need to get table from comma separated values in SQL Server. For example if you want to get list of employee details from comma separated employee ids, you need to include “IN” clause in select statement. If you want to include this scenario in stored procedure and pass the comma…

    Read more
  • Turn Off Skype at Startup Windows
    2 Comments

    In the latest version of Skype application, there is no option provided to turn off Skype at windows startup as like previous version. Do the following steps to turn off Skype at startup windsows. Click the start menu and do search “msconfig” using “Search programs and files”, You will get “msconfig.exe” file. ( Or you…

    Read more
  • Interesting Facts About Numbers
    No Comments

    The letters A,B,C and D do not appear in the spelling of 1 to 99 (That is ONE, TWO, .. NINETY NINE). And D appears first time in HUNDRED. The A appears first time in THOUSAND. The B appears first time in BILLION. The C appears first time in CRORE. Very interesting isn’t it?

    Read more

Socials

Newsletter

Back to Top