• If you right clink on the table you wish to insert values into and select script table as > Insert > New Query Editor Window, you will get something like this:

    INSERT INTO [dbo].[EventErrors]

    ([FileID]

    ,[ErrorMessage]

    ,[EventErrorObjectType]

    ,[Activity])

    VALUES

    (<FileID, int,>

    ,<ErrorMessage, nvarchar(255),>

    ,<EventErrorObjectType, nvarchar(255),>

    ,<Activity, nvarchar(255),>)

    GO

    Makes it easy to know where to put what as you finish the script.