SQL Server Exporting a Table to a Text File Part ...
This post continues from the first part. In this example the directory has a space in it so […]
Blog
SQL Server Exporting a Table to a Text File
This post describes how to export a SQL Server table to a text file using a stored procedure. […]
Julian Calendar
Julian Date Calendar for Regular Years (not leap years) (2013-2015, 2017-2019, 2021-2023, 2025-2027, 2029-2031…) Jan Feb Mar Apr […]
SQL Server char and varchar Data Types
CHAR is a fixed-length, non-Unicode string data. n defines the string length and must be a non-fractional value […]
SQL Server right() function with cast()
The right() function returns the right part of a character string with the specified number of characters. It […]
SQL Server UNION and UNION ALL
The UNION, EXCEPT and INTERSECT operators are relational operators that combine rows from the results sets of two […]
SQL Server CLR Assemblies
CLR stands for Common Language Runtime. This blog post is about writing SQL Server stored procedures and functions […]
Windows PowerShell Introduction
Windows PowerShell is the command and scripting language from Microsoft built into all versions of Windows since Windows […]
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 […]
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 […]