how to insert new record in my table if not exists?sql server 2005 - CodeProject

Free source code and tutorials for Software developers and Architects.; Updated: 27 Feb 2011 ... so it should be: insert into tablename (code) Select '1448523' From tablename Where not exists(select * from tablename where code='1448523')

www.codeproject.com