Sql 判断数据是否存在
string sql=@"
IF NOT EXISTS (SELECT * FROM Roche_datadictionary WHERE code LIKE '001')
BEGIN
INSERT INTO Roche_datadictionary(code) VALUES ('tom')
END
";
IF NOT EXISTS (SELECT * FROM Roche_datadictionary WHERE code LIKE '001')
BEGIN
INSERT INTO Roche_datadictionary(code) VALUES ('tom')
END
";
浙公网安备 33010602011771号