按 email 去重插入
INSERT INTO users (id, name, email) VALUES (1, '张三', 'test@qq.com') ON CONFLICT (email) DO NOTHING;
不存在插入，存在就更新
INSERT INTO users (id, name, age) VALUES (1, '张三', 20) ON CONFLICT (id) DO UPDATE SET name = EXCLUDED.name, age = EXCLUDED.age;
https://blog.csdn.net/h1773655323/article/details/142454517...
delete from article_author;dbcc checkident('article_author',reseed,0)...
TRUNCATE TABLE tpl_template_class RESTART IDENTITY; ALTER SEQUENCE ...
SELECT format( 'SELECT setval(%L, COALESCE((SELE...
delete from article_author;dbcc checkident('article_author',reseed,0)...
EXEC sys.sp_addextendedproperty @name=N'MS_Description',@level1type=N'TABLE...
