quote:

---

Originally posted by mrleokarthik

Is it possible to create a function that deletes records from a table ?

CREATE FUNCTION F_TSImported_Delete()
returns int
as
Begin
delete from ts_imported
return 0
end
GO

This throws error like this:
Invalid use of side-effecting or time-dependent operator in 'DELETE' within a function.

---

quote:

---

Originally posted by JustDaveN

Just as an FYI, you can call a stored procedure from within your function. If you need to keep what you are doing as a function, you can take the external table changes and put it in a stored proc, then call it.

A lot of folks would ask why you would want to do this. For my specific example, I had written a table function that was used in several stored procedures. It worked well as the function ended up changing and rather than having to change this block of code in 10 or more procs, I only had to change it once. Later, a business requirement was added to log some intermediate calculations that were used in determining the data set returned. I added a procedure call to log the value in an external table.

HTH
David

---

CREATE PROCEDURE cg_write_val
AS BEGIN
	SELECT 'a' AS [Foo] INTO _test
END
GO

CREATE FUNCTION myFunc
	(@foo INT) RETURNS INT
AS BEGIN
	EXEC cg_write_val
	SET @foo = -1
	RETURN @foo
END
GO

SELECT dbo.myFunc(1)

Msg 557, Level 16, State 2, Line 2
Only functions and extended stored procedures can be executed from within a function.