insert syntax

Posted on 2005-04-21
Last Modified: 2010-03-19

I get a syntax error when I try to insert into the db the following values : syntax error neat getdate. WHat could it be?

insert into mytable(1,'A:\disk1','myfile',2,getdate(),getdate(),20)

the fields are bigint, varchar(8000),varchar(200), int,datetime,datetime,int
Question by:LuckyLucks
    1 Comment
    LVL 28

    Accepted Solution

    You forgot the word VALUES:

    insert into mytable values (1,'A:\disk1','myfile',2,getdate(),getdate(),20)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    The steps for moving the system databases to a new location are documented in the following technical article: However sometimes after the moving process is finished, though SQL i…
    When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now