Can you tell me what is wrong with this query? I'm getting the following error:

Server: Msg 156, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'where'.

Here's the T-SQL insert Into tbl_ScannedFiles (Folder, Path, FilName, DMIS, Loc, LName, SSN, PatCat, RegNbr) Values '\21cshfolder', '\fullpath', 'FileName', '0109', 'IZ', 'TATE', '475527006', 'A99', '1234567') where NOT EXISTS (SELECT * FROM tbl_ScannedFiles WHERE FilName = 'FileName')

    Requires Free Membership to View

    Login

You can't put a WHERE clause on an INSERT statement after a VALUES clause. Change it to this structure:

IF NOT EXISTS(…..) INSERT INTO … VALUES(…) View questions and answers from all of our SQL Server experts here.

This was first published in March 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top