I have created a scalar function
CREATE FUNCTION dbo.Dumm() returns INT AS BEGIN DECLARE @a INT SELECT @a = 1 RETURN @a END
Now I am calling the scalar function through
Exec not through
It did not return
1. It just says
Command(s) completed successfully.
Whats happening internally. Is there any meaning for it ?