Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sanjnep
Posting Yak Master
191 Posts |
 Posted - 2007-03-29 : 14:02:39
|
| I have calculated column which is referenced by function and I need to alter the function. How can I disable the calculated column so I am able to modify the function?..................................................................I have orders table and I need to disable the calculated column OrderDate so I may able to modify the function dbo.udfTicksToDateTime.CREATE TABLE Orders ( OrderDateAsTicks BIGINT, OrderDate AS dbo.udfTicksToDateTime(OrderDateAsTicks))Thanks Sanjeev Cleveland |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-03-29 : 14:14:34
|
| You must drop the column, edit the function, and the add the column again.Peter LarssonHelsingborg, Sweden |
 |
|
|
sanjnep
Posting Yak Master
191 Posts |
Posted - 2007-03-29 : 15:06:02
|
| Thanks PESO |
|
|
|
|
|
|
How to disable calculated column?