sql 存在更新，不存在插入

sqlserver

1、语法

if exists (select * from users where name='张三')
	print 1
ELSE
	print 0

2、建表语句

CREATE TABLE [dbo].[users] (
[id] int NOT NULL IDENTITY(1,1) ,
[name] varchar(50) NULL ,
[sex] varchar(5) NULL 
)
GO
SET IDENTITY_INSERT [dbo].[users] ON
GO
INSERT INTO [dbo].[users] ([id], [name], [sex]) VALUES (N'1', N'李四', N'女');
INSERT INTO [dbo].[users] ([id], [name], [sex]) VALUES (N'2', N'张三', N'女');
INSERT INTO [dbo].[users] ([id], [name], [sex]) VALUES (N'3', N'王五', N'男');

3、例子，存在更新，不存在插入

if exists (select * from dbo.users s where s.name='张三')
	update users set sex='男' where name = '张三'
ELSE
	insert into users (name,sex) values ('张三','女')

—————————————————————————————————