Popular posts
-
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... -
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... -
Custom buttons are added to the toolbars or ribbons when a Microsoft Excel sheet is opened, and removed when the sheet is closed. To be noti...
-
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...
-
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 ...
-
Transact-SQL does not offer a good way to support constants in your stored procedures or userdefined functions. This means that you either ...
-
It is not straight forward to create an atomic insert or update statement in SQL Server, i.e. we update the row if it exists. Otherwise we i...
-
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...
-
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 ...
-
The non-reversable hashing algorithm MD5 is supported in Microsoft SQL Server, but is not directly accessable though a simple transact-SQL ...