Breaking News: Grepper is joining You.com. Read the official announcement!

if not exists in sql

Add Answer

Santino answered on March 12, 2021 Popularity 10/10 Helpfulness 4/10

answer if not exists in sql

related SQL NOT EXISTS

related sql select if not exists

related sql not exists

related not exists in sql

if not exists in sql

Comment

At first glance your original attempt seems pretty close. I'm assuming that clockDate is a DateTime fields so try this:

IF (NOT EXISTS(SELECT * FROM Clock WHERE cast(clockDate as date) = '08/10/2012') 
    AND userName = 'test') 
BEGIN 
    INSERT INTO Clock(clockDate, userName, breakOut) 
    VALUES(GetDate(), 'test', GetDate()) 
END 
ELSE 
BEGIN 
    UPDATE Clock 
    SET breakOut = GetDate()
    WHERE Cast(clockDate AS Date) = '08/10/2012' AND userName = 'test'
END 
Note that getdate gives you the current date. If you are trying to compare to a date (without the time) you need to cast or the time element will cause the compare to fail.

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(clockDate, userName, breakOut) 
    VALUES(GetDate(), 'test', GetDate()) 
END 
ELSE 
BEGIN 
    UPDATE Clock 
    SET breakOut = GetDate()
    WHERE clockDate = '08/10/2012' AND userName = 'test'
END 
As others have pointed out, the merge statement is another way to tackle this same logic. However, in some cases, especially with large data sets, the merge statement can be prohibitively slow, causing a lot of tran log activity. So knowing how to logic it out as shown above is still a valid technique.

Popularity 10/10 Helpfulness 4/10 Language typescript

Source: Grepper

Tags: not-exists sql typescript

Link to this answer
Share Copy Link

Contributed on Mar 12 2021

Santino

0 Answers Avg Quality 2/10

Closely Related Answers

SQL NOT EXISTS

Comment

SELECT customer_id, first_name
FROM Customers
WHERE NOT EXISTS (
  SELECT order_id
  FROM Orders
  WHERE Orders.customer_id = Customers.customer_id
);

Popularity 10/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: not-exists n

Link to this answer
Share Copy Link

Contributed on May 22 2022

SAMER SAEID

0 Answers Avg Quality 2/10

sql select if not exists

Comment

BEGIN
   IF NOT EXISTS (SELECT * FROM EmailsRecebidos 
                   WHERE De = @_DE
                   AND Assunto = @_ASSUNTO
                   AND Data = @_DATA)
   BEGIN
       INSERT INTO EmailsRecebidos (De, Assunto, Data)
       VALUES (@_DE, @_ASSUNTO, @_DATA)
   END
END

Popularity 10/10 Helpfulness 4/10 Language sql

Source: stackoverflow.com

Tags: not-exists n

Link to this answer
Share Copy Link

Contributed on Jun 29 2022

Homeless Heron

0 Answers Avg Quality 2/10

sql not exists

Comment

-- The SQL NOT EXISTS Operator will act quite opposite to EXISTS Operator. 
-- It is used to restrict the number of rows returned by the SELECT Statement.

SELECT column_name
FROM table_name
WHERE NOT EXISTS (Write Subquery to Check);

Popularity 10/10 Helpfulness 2/10 Language sql

Source: Grepper

Tags: not-exists n

Link to this answer
Share Copy Link

Contributed on Dec 08 2021

Jolly Jay

0 Answers Avg Quality 2/10

not exists in sql

Comment

SELECT [Column Names]
FROM [Source]
WHERE NOT EXISTS (Write Subquery to Check)

Subquery: Here we have to provide the Subquery. If the subquery returns true then it will return the records otherwise, it doesn’t return any records.

Popularity 9/10 Helpfulness 2/10 Language typescript

Source: www.tutorialgateway.org

Tags: not-exists n

Link to this answer
Share Copy Link

Contributed on Mar 10 2023

Pleasant Petrel

0 Answers Avg Quality 2/10

if not exists in sql

Contents

More Related Answers

if not exists in sql

Closely Related Answers

SQL NOT EXISTS

sql select if not exists

sql not exists

not exists in sql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.