If condition in SQL Server 2008

by 

 update AccountHistory
 set amount = amount * -1
 where accounttype="Withdrawal";

More Related Contents:

  1. Export from SQL Server to Excel
  2. How to get cumulative sum
  3. How to check if a column exists in a SQL Server table
  4. How to get a float result by dividing two integer values using T-SQL?
  5. Get first day of week in SQL Server
  6. SQL Server query to find all permissions/access for all users in a database
  7. SQL Server add auto increment primary key to existing table
  8. How to delete large data of table in SQL without log?
  9. What is the maximum characters for the NVARCHAR(MAX)? [duplicate]
  10. How do I view the full content of a text or varchar(MAX) column in SQL Server 2008 Management Studio?
  11. Do while loop in SQL Server 2008
  12. Query times out when executed from web, but super-fast when executed from SSMS
  13. TSQL: How to convert local time to UTC? (SQL Server 2008)
  14. How to update primary key
  15. error when inserting into table having instead of trigger from entity data framework
  16. Case sensitive variables in SQL Server
  17. Transpose rows and columns with no aggregate
  18. SQL Server Configuration Manager cannot be found
  19. SQL Server recursive query
  20. How do I move a table into a schema in T-SQL
  21. nvarchar(max) vs NText
  22. How to display two digits after decimal point in SQL Server
  23. How to find the boundaries of groups of contiguous sequential numbers?
  24. In SQL Server, how can I find everywhere a column is referenced?
  25. What are row, page and table locks? And when they are acquired?
  26. Using Full-Text Search in SQL Server 2008 across multiple tables, columns
  27. Error converting data types when importing from Excel to SQL Server 2008
  28. CHECKSUM and CHECKSUM_AGG: What’s the algorithm?
  29. SQL Server 2008 Spatial: find a point in polygon
  30. Implementing one-to-zero-or-one relation in SQL Server

Leave a Comment