IF Select Statement failing

Question

My statement below is failing withthe below:

Msg 156, Level 15, State 1, Line 1

Incorrect syntax near the keyword 'SELECT'.

Msg 102, Level 15, State 1, Line 1

Incorrect syntax near '<'.

Msg 102, Level 15, State 1, Line 10

What is wrong with the below statement?

IF Select DATENAME(dw,GETDATE()) = 'Monday'

Begin

Update statement is here

Answer 1

You don't need SELECT in that statement, e.g.

IF DATENAME(weekday, CURRENT_TIMESTAMP) = 'Monday'

    BEGIN

      update statement here

   END

---

For every expert, there is an equal and opposite expert. - Becker's Law


My blog

Answer 2

IF DATENAME(dw,GETDATE()) = 'Monday'

Begin

Answer 3

The short answer is that you do not need the SELECT. The right answer is that you do not know how to write SQL and are still writing BASIC. SQL is a declarative language, so we do not use IF-THEN flow control or loops. We do not write code that is language dependent like you did. We also have the ANSI/ISO Standard CURRENT_TIMESTAMP now. Here is the skeleton.

UPDATE Foobar
   SET floob = ???
 WHERE DATEPART(DW, CURRENT_TIMESTAMP)) = 1;

 

---

--CELKO-- Books in Celko Series for Morgan-Kaufmann Publishing: Analytics and OLAP in SQL / Data and Databases: Concepts in Practice Data / Measurements and Standards in SQL SQL for Smarties / SQL Programming Style / SQL Puzzles and Answers / Thinking in Sets / Trees and Hierarchies in SQL

Answer 4

Hi

Please try

if(datename(Dw,getdate())='Monday')
begin
Update statement is here

---

Ahsan Kabir Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread. http://www.aktechforum.blogspot.com/