simple userdefined function question.

[parez]

Hi All!

This is the first time i am tryin to write a sql server 2000 function.
I need to clean up some of my stored procedures..

Can any one please give me skeleton for a userdefined function or
correct my function. I get the following error.

Select statements included within a function cannot return data to a
client.

This returns a bit and it does a query to the database to decide the
value of the bit

CREATE FUNCTION GoodAd
(@adid int,@currentdat e datetime)
RETURNS bit
AS
BEGIN
declare @Return bit
select @return = 1

if exists (select null from adqas where adid=@adid)
select @return 0
return @return
end

[Erland Sommarskog]

[posted and mailed, please reply in news]

parez (ps*****@gmail. com) writes:

This is the first time i am tryin to write a sql server 2000 function.
I need to clean up some of my stored procedures..

Can any one please give me skeleton for a userdefined function or
correct my function. I get the following error.

Select statements included within a function cannot return data to a
client.
Looks like a simple syntax error to me:
CREATE FUNCTION GoodAd
(@adid int,@currentdat e datetime)
RETURNS bit
AS
BEGIN
declare @Return bit
select @return = 1

if exists (select null from adqas where adid=@adid)
select @return 0

I guess you mean:

select @return = 0


--
Erland Sommarskog, SQL Server MVP, es****@sommarsk og.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[parez]

Yes