Popular posts
-
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...
-
If you choose to run your website in a shared hosting environment on windows servers, most webhosts don't allow you to schedule your own...
-
To get only the Time portion of a DateTime variable in Transact-SQL, you can use the following function: -- Returns only the time portion...
-
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...
-
Since the announcement of the new Facebook requirement regarding the support of secure canvas for both Facebook Apps and Facebook Pages (fro...
-
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...
-
The non-reversable hashing algorithm MD5 is supported in Microsoft SQL Server, but is not directly accessable though a simple transact-SQL ...
-
Transact-SQL does not offer a good way to support constants in your stored procedures or userdefined functions. This means that you either ...
-
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... -
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...