T-SQL Parsing Into Many Columns
This post is about working with one column in a SQL Server table that contains a comma-separated list […]
T-SQL
WPF Read a SQL Server Table into a DataGrid
This post is about how to connect to a local SQL Server database and read a table from […]
SQL Server Create Table
You can create a table using the SSMS GUI, or you can use T-SQL code. This post describes […]
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 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 CLR Assemblies
CLR stands for Common Language Runtime. This blog post is about writing SQL Server stored procedures and functions […]
SQL Server Introduction
Wikipedia says: “Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, […]
TSQL Language Notes
Begin Coding Now has a Microsoft Word file with a few pages of crib notes on Microsoft TSQL […]