SQL Server Import Data from a Text File
This post is the first part of a multi-part series. First we will look at what we need […]
Blog
Google Account Introduction
If you have a gmail email, then you already have a Google account. They are really the same […]
Google Drive Introduction
Wikipedia says the following about Google Drive: “Google Drive is a file storage and synchronization service operated by […]
G Suite Introduction
G Suite (formerly Google Apps for Work and Google Apps for Your Domain) is a brand of cloud […]
Gmail Introduction
Gmail is a free, advertising-supported email service developed by Google. Users can access Gmail on the web and […]
SQL Server AdventureWorks2014 Installation
You may wish to install a sample database from Microsoft called Adventure Works 2014. The reason you may […]
Transform an XML Document’s Attributes into Elements
If you have an XML document that uses attributes only, you can easily transform that document into a […]
SQL Server Select Table with Parameter in Sproc
This post shows you how to run a SELECT query in a stored procedure that takes as a […]
Notepad++ Text Editor
Most computer programmers use more than one text editor. I have Notepad++, Sublime Text, Atom and Visual Studio […]
SQL Server T-SQL Rowcount
Microsoft’s T-SQL has a global variable called @@ROWCOUNT that returns the number of rows affected by the last […]
SQL Server bcp error
You may get the following error while running a SQL Server command xp_cmd. Please refer to the previous […]
SQL Server Exporting Data Programatically with bcp and xp_cmdshell
Many times you may find that you need to take some data in a table or tables and […]