Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)

  • RE: Importing Excel data to SSMS

    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...

  • RE: Importing Excel data to SSMS

    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...

  • RE: Importing Excel data to SSMS

    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'

  • RE: Importing Excel data to SSMS

    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:

    Address Address Street Name ...

  • RE: Importing Excel data to SSMS

    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...

  • RE: Importing Excel data to SSMS

    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...

Viewing 6 posts - 1 through 6 (of 6 total)