SQL Server AdventureWorks2014 Installation
You may wish to install a sample database from Microsoft called Adventure Works 2014. The reason you may […]
SQL Server
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 […]
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 […]
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 […]
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. […]
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 […]