Could not reproduce:--- Ran this first
create function dbo.Junk(@x int)
returns int
as
begin
return @x;
end
go
--- Ran from here down in SSMS
alter function dbo.Junk(@x int, @y int)
returns int
as
begin
return @x + @y;
end
go
select dbo.Junk(1, 2);
go
drop function dbo.Junk;
Runs fine in SSMS. No errors; no warnings. Are you missing the '@' as the initial character in the function parameters?
=================================================
Hear the sledges with the bells - silver bells!
What a world of merriment their melody foretells!