LazerWire

Technology and software development

About Me

Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Home
Subscribe to: Posts (Atom)

Search This Blog

Popular posts

  • Excel VBA: Display the Developer Toolbar or Ribbon
    By default the developer toolbar or ribbon (depending on the Excel version) is hidden in Microsoft Excel. In Excel 2007 and later it can b...
  • Excel VBA: Download files from the Internet
    There is no built-in function in Microsoft Excel which allows you to download contents from the Internet on the fly. To accomplish this task...
  • MS SQL: Create Date
    There is no straight forward function in Transact-SQL to create a simple date based on year, month and day. Below we have created a userdefi...
  • Excel VBA: Get all selected rows
    If the user does does a selection of rows in Excel, the selection can contain multiple areas . An area is a subselection of rows created whe...
  • MS SQL: Url Encode
    There is no built-in function in Microsoft SQL Server to to support URL encoding. If you want to generate URLs with arguments on the fly in ...
  • MS SQL: First Day of Week
    In Transact-SQL the first day of week can be calculated based on the @@FirstDay system variable. The variable will return different values ...
  • MS SQL: Custom Date and Time functions
    Transact-SQL really lack a the neccessary support for creating and modifying dates and times. Now and then I have the need for creating cust...
  • Excel VBA: Adding custom buttons to the Right-Click popup menu
    In Microsoft Excel it is possible to extend the right click popup menu by using VBA. The right click menu is implemented as a special Comman...
  • MS SQL: MD5 Hash
    The non-reversable hashing algorithm MD5 is supported in Microsoft SQL Server, but is not directly accessable though a simple transact-SQL ...
  • MS SQL: Create Time
    To create a new DateTime value for a given date and a given time, we can use the userdefined function below. We start by retrieving the raw ...

Blog archive

  • ▼  2011 (35)
    • ▼  November (7)
      • Excel VBA: Display the Developer Toolbar or Ribbon
      • Visual Studio 2010: Debug the .NET assemblies
      • Excel VBA: Adding custom Button to the Toolbar or ...
      • Excel VBA: Adding custom buttons to the Right-Clic...
      • Excel VBA: String Format
      • Excel VBA: Download files from the Internet
      • Excel VBA: Re-throw error/exception
    • ►  October (28)

Followers

Pages

  • Start
  • About Me
  • Directories

Sites

  • ImagePrint - Print Photos at Home
  • Coragi

Labels

  • .net (7)
  • 2003 (1)
  • 2007 (1)
  • 2010 (1)
  • api (1)
  • argb (1)
  • array (1)
  • asp.net (3)
  • assembly (1)
  • atomic (1)
  • bandwidth (1)
  • blogger (1)
  • blogspot (1)
  • button (1)
  • C# (3)
  • calendar (2)
  • certificate (1)
  • code (3)
  • codeplex (1)
  • color (1)
  • constant (1)
  • convert (1)
  • cron (1)
  • css (1)
  • date (8)
  • dateadd (5)
  • datediff (4)
  • datefirst (1)
  • datepart (1)
  • datetime (8)
  • day (2)
  • dayofweek (3)
  • debug (1)
  • decompile (1)
  • design (2)
  • developer (1)
  • development (2)
  • download (1)
  • e-mail (1)
  • encode (1)
  • error (1)
  • excel (11)
  • exception (1)
  • facebook (3)
  • facebook app (3)
  • firstdayofweek (1)
  • fn_varbintohexstr (1)
  • format (1)
  • free (3)
  • free ssl (2)
  • function (6)
  • google (1)
  • group (1)
  • hash (1)
  • HashBytes (1)
  • hashing (1)
  • holdlock (1)
  • hostgator (1)
  • hour (2)
  • ie (1)
  • insert (1)
  • internet explorer (2)
  • ix web (1)
  • java (2)
  • javascript (1)
  • linux (1)
  • lock (1)
  • MAPI (1)
  • md5 (1)
  • microsoft (19)
  • microsoft excel (1)
  • microsoft office (1)
  • minute (2)
  • month (2)
  • MS SQL (11)
  • october 1st (1)
  • office (3)
  • options (1)
  • outlook (1)
  • php (1)
  • picture (1)
  • png (1)
  • procedure (5)
  • programmer (1)
  • programming (19)
  • query argument (1)
  • range (1)
  • reflector (1)
  • rendering (1)
  • rgb (1)
  • ribbon (3)
  • row (1)
  • rowlock (1)
  • scheduled task (1)
  • scheduling (1)
  • schemabinding (1)
  • SDK (1)
  • second (2)
  • selection (1)
  • shared hosting (1)
  • SP (1)
  • split (1)
  • SQL (14)
  • SQL Server (5)
  • ssl (1)
  • StartCom (1)
  • storage (2)
  • string (2)
  • stringbuilder (1)
  • substring (1)
  • sum (1)
  • SVG (1)
  • table (1)
  • template (1)
  • time (5)
  • toolbar (3)
  • transact-SQL (9)
  • transaction (2)
  • transparent (1)
  • UDF (8)
  • ui (1)
  • update (1)
  • updlock (1)
  • upsert (1)
  • url (2)
  • url decode (1)
  • url encode (1)
  • userdefined (6)
  • variant (1)
  • vba (10)
  • visual basic (1)
  • visual studio (3)
  • web (5)
  • webclient (1)
  • webdesign (1)
  • webhosting (4)
  • weekday (1)
  • windows (3)
  • wininet (1)
  • workbook (1)
  • worksheet (1)
  • year (2)
Simple theme. Powered by Blogger.