Import XML File to Excel Part 2
This blog post continues from the previous one called Import XML File to Excel. Now, assume we have […]
Blog
HTML List Maker
If you type a lot of HTML code undoubtedly you will have types ordered and unordered lists. There […]
Import XML File to Excel
In this blog post we follow the instruction at the MSDN website’s article Creating an XML Mapping Schema […]
Sublime Text Multiple Files
Sometimes you want to be able to easily work with two or more files at one time. You […]
Sublime Text Projects
In Sublime Text you can set up a “project” that has more than one folder and more than […]
Convert Case Online
Do you need to convert some text from one case to another? Perhaps you left the Caps lock […]
SQL Server Date Conversion Function
Here we have a couple of code examples that work with dates. The first one gets today’s date […]
SQL Server Finding Bad Characters
In SQL Server you can run a SELECT query that shows you all of the records that have […]
SQL Server T-SQL Statements
As mentioned earlier, the Transact-SQL statements have three categories: DDL statements, DCL statements, and DML statements. Each of […]
SQL Server User-Defined Functions
In SQL Server, user-defined functions (UDFs) are similar to stored procedures, except that they do not support OUTPUT […]
SQL Server T-SQL Variables
We need to back to basics in our Transact SQL (T-SQL) studies and look at programming with variables. […]
SQL Automatically Date and Time Stamp New Rows
You may to date and time stamp every row/record that you add to your table. You may want […]