SQL Server防止重复插入

--防止重复插入SQL
if  not exists (select * from tablename where 姓名='张三') Insert Into [tablename] ([班级],[姓名],[E16列],[卡号]) Values('2班','张三','e59bbb6d','2314885530818453536');