DROP TABLE IF EXISTS dbo.please_remove;
GO

CREATE TABLE dbo.please_remove (
first_col int NOT NULL
);
GO
INSERT INTO dbo.please_remove
(first_col)
VALUES
(1);
GO

CREATE OR ALTER FUNCTION [dbo].[itv_fn_please_remove] (@id int)
RETURNS TABLE 
WITH SCHEMABINDING AS 
RETURN (
SELECT @id AS...

Hi David. Thanks for pointing that out and as you mentioned, schemabinding will prevent changes to the underlying objects, rather than the function. A better BOL definition can be found...

• This reply was modified 4 years, 6 months ago by  kimani_m.

Thank you Jeff and also, thank you for pointing out that you can certainly call a stored procedure within a function.
I ran the following script on my Dev machine...

Thanks Eirikur. Hope you found it useful.

Glad you found it easy to understand sqlfriends. Thank you.

Thank you <a title="Go to ChrisM@Works.