string sql = @"
IF EXISTS (SELECT * FROM [表] WHERE [name]='tom')
UPDATE [表] SET [age]=20 WHERE [name]='tom'
ELSE BEGIN
INSERT INTO [表] ([name],[age],[sex]) VALUES ('tom',20,'male')
END
";
IF EXISTS (SELECT * FROM [表] WHERE [name]='tom')
UPDATE [表] SET [age]=20 WHERE [name]='tom'
ELSE BEGIN
INSERT INTO [表] ([name],[age],[sex]) VALUES ('tom',20,'male')
END
";