Thanks Koen, I picked up Microsoft SQL Server 2012 on Amazon. I was torn between the book you suggested (Microsoft SQL Server and Murach's SQL 2012. I decided to...

Hey Koen,

This is the script generated when I use 'Set Primary Key'

USE [Troubleshoot]

GO

/****** Object: Table [dbo].[TestTable] Script Date: 3/20/2015 12:32:18 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER...

From the table designer I right click the column I want to make the primary key then from the drop down menu that appears I select 'Set Primary Key'

Kutang and Koen,

Here is a sample of the data from one of the Excel sheets I want to import to one of my tables:

AddressAddress Street Name ...

Hello Kutang and Koen,

Here is a sample of the script generated from one of the tables. All of the scripts for the tables are all similar to this. There are...

My apologies everyone I made a mistake in my original post.

I stated that the primary key column had to have a 'NULL' value when in actuality the primary key must...