Msg 5074, Level 16, State 1, Line 4
The column 'dblSigmaB' is dependent on column 'dblDiam0'.
Msg 4922, Level 16, State 9, Line 4
ALTER TABLE ALTER COLUMN dblDiam0 failed because one or more objects access this column.

ALTER TABLE LabData ALTER COLUMN dblDiam0 real NULL

Computed Column Specification: ([dbo].[SigmaB]([nPb], [dblDiam0]))

USE [st]
GO
/****** Object:  UserDefinedFunction [dbo].[SigmaB]    Script Date: 06.05.2021 9:30:40 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER FUNCTION [dbo].[SigmaB] (@nPb int, @dblDiam0 real)  
RETURNS real AS  
BEGIN 
DECLARE @dblS0 real
DECLARE @dblS real

IF (@dblDiam0 <> 0)
BEGIN
	SET @dblS0 = round(3.14 * @dblDiam0 * @dblDiam0 / 4.0,2);
	SET @dblS = convert(real,round(convert(real,(convert(real,@nPb) / @dblS0)),1))
END
ELSE
	SET @dblSigmaB = NULL

RETURN @dblSigmaB
END