SQL Server 2008 - IF NOT EXISTS INSERT ELSE UPDATE - Stack Overflow

SQL Server 2008 - IF NOT EXISTS INSERT ELSE UPDATE - Stack Overflow

瀏覽:433
日期:2025-04-23
If clockDate is NOT datetime field (just date), then the SQL engine will do it for you - no need to cast on a set/insert statement. IF (NOT EXISTS(SELECT * FROM Clock WHERE clockDate = '08/10/2012') AND userName = 'test') BEGIN INSERT INTO Clock ......看更多