Posts

Showing posts with the label SQL Server

CASE Statements in A SQL UPDATE Query

UPDATE [account] SET balance = ( CASE WHEN ((balance - 10.00) < 0) THEN 0 ELSE (balance - 10.00) END ) WHERE condition

Last_date

There is no function like last_date in sql server.

Maximize SQL Server Performance with SQL Tuning

Image