I want create on function in sql with :
CREATE FUNCTION [dbo].[TESTT] ()
DECLARE @temp BIGINT
select @temp =
I can create function and see it in scalar-function
But when i used the function, don't show it. with following command.
TESTT don't exist in list!
to run the function use -- select dbo.testt()
make sure, your function was created in the same database..
run this to see if the function was actually created
select * from sys.objects where name = 'testt' and type='fn'
Also, it looks like you actual query has more to it, may be there is some syntax wrong in there..please post the actual syntax and that can help better..
Hope it Helps!!
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?