How can I alter this computed column in SQL Server 2008?

by

Something like this:

ALTER TABLE dbo.MyTable
DROP COLUMN OldComputedColumn

ALTER TABLE dbo.MyTable
ADD OldComputedColumn AS OtherColumn + 10

Source

More Related Contents:

  1. Sql Server deterministic user-defined function
  2. formula for computed column based on different table’s column
  3. Is it possible to write single query on two table which are not connected to each other?
  4. Is the NOLOCK (Sql Server hint) bad practice?
  5. How to create composite primary key in SQL Server 2008
  6. OPTION (RECOMPILE) is Always Faster; Why?
  7. sql runs fast in ssms slow in asp.net
  8. Sub queries in check constraint
  9. Rename column SQL Server 2008
  10. How do I use structural annotations to set SQL type to Date in model first approach
  11. Compare DATETIME and DATE ignoring time portion
  12. Split function in SQL Server 2008
  13. Remove numbers from string sql server
  14. How to find third or nᵗʰ maximum salary from salary table?
  15. SQL “between” not inclusive
  16. Selecting first row per group
  17. Using PIVOT in SQL Server 2008
  18. sql group by only rows which are in sequence
  19. Function in SQL Server 2008 similar to GREATEST in mysql?
  20. SQL server join tables and pivot
  21. How to retrieve field names from temporary table (SQL Server 2008)
  22. Why can’t I use an alias for an aggregate in a having clause?
  23. Using a database table as a queue
  24. When using GETDATE() in many places, is it better to use a variable?
  25. SQL . The SP or function should calculate the next date for friday
  26. Backup a single table with its data from a database in sql server 2008
  27. COALESCE Function in TSQL
  28. SQL Server equivalent to MySQL’s EXPLAIN
  29. Try_Convert for SQL Server 2008 R2
  30. SQL: Using DATEADD with bigints

Leave a Comment