Server: Msg 156, Level 15, State 1, Line 3 Incorrect syntax near the keyword 'where'.
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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')
IF NOT EXISTS(…..) INSERT INTO … VALUES(…) View questions and answers from all of our SQL Server experts here.
Dig Deeper on SQL-Transact SQL (T-SQL)
Related Q&A from Greg Low
Should developers be granted permissions to production queue in a SQL Server environment? See why expert Greg Low suggests proc access by WITH ...continue reading
A SQL Server application that needs user permission to create and modify tables in SQL Server 2005 may be handled best via a schema.continue reading
Find how to save stored procedure output to the network drive via SQL Server Management Studio.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.