SQL Server INSERT Example

INSERT - Row

Insert a row of data. Note: the minimum requirements for and insert must include columns that are part of the primary key, part of indexes where no duplicates are allowed, and all columns that cannot be null.

BEGIN TRANSACTION
GO

INSERT INTO [dbo].[Courses]
     (
        course_designater               ,
        course_name                     ,
        education_delivery_method       ,
        course_description_short        ,
        course_description_long         ,
        course_syllabus_attachment      ,
        course_materials_zip_attachment ,
        course_materials_location       ,
        max_recommended_enrollment      ,
        convenings                      ,
        convenings_details              ,
        convenings_consecutive_flg      ,
        typical_preclass_prep_time      ,
        typical_postclass_prep_time     ,
        typical_convening_time          ,
        sponser_name                    ,
        active_flg                      ,
        inactive_date                   ,
        inactive_reason                 ,
        employee_inactivating           
     ) 
VALUES
     (
        'Powerpoint200' , 
        'Intermediate Powerpoint' , 
        'Classroom' , 
        NULL , 
        NULL , 
        'ThirdPartyEduc\OfficeAssoc\IntemediatePowerpoint.pdf' , 
        NULL , 
        NULL , 
        16 , 
        1 , 
        NULL , 
        1 , 
        NULL , 
        NULL , 
        NULL , 
        NULL , 
        1 , 
        NULL , 
        NULL , 
        0 
     ) 
GO

COMMIT TRANSACTION
GO

If you find this site useful and are a book buyer/reader... You can support my site by clicking on one of the Links below to Abe books By doing this, I will receive a small commision on your purchase and making your purchase will not cost you any more money than if you went directly the site yourself! Abe Books sells books at a fraction of the original cost. I have purchased many books from them originally cost $40.00 for as little as $5 to $10 dollars including shipping costs Click on applicable icon to find books at Abe Books on ...
SQL Server 2008	SQL Server 2005	SQL Server 2000	T-SQL

Abe Books is one of my affiliates. I only use affiliates that I also purchase products from. I love Abe books. If it is printed they likely have a copy. I have also included a generic link to Abe Books below. Once on their site, you will find that they have a nice, easy to use search engine so to find what you are looking for.