Developer Programmer
سه شنبه 06 فروردین 1387, 11:49 صبح
به دو پروسیجر زیر دقت کنید
CREATE PROCEDURE ut_MidPoint @LowerNumber int, @HigherNumber int
AS
BEGIN
DECLARE @Mid int
IF @LowerNumber > @HigherNumber
RAISERROR('You have entered your numbers the wrong way round',16,1)
SET @Mid = ((@HigherNumber - @LowerNumber) / 2) + @LowerNumber
SELECT @Mid
END
CREATE PROCEDURE checkstate @param varchar(11)
AS
IF (SELECT state FROM authors WHERE au_id = @param) = 'CA'
RETURN 1
ELSE
RETURN 2
چرا یه جا از Return و یه جا از Select استفاده میکنیم ؟!!
CREATE PROCEDURE ut_MidPoint @LowerNumber int, @HigherNumber int
AS
BEGIN
DECLARE @Mid int
IF @LowerNumber > @HigherNumber
RAISERROR('You have entered your numbers the wrong way round',16,1)
SET @Mid = ((@HigherNumber - @LowerNumber) / 2) + @LowerNumber
SELECT @Mid
END
CREATE PROCEDURE checkstate @param varchar(11)
AS
IF (SELECT state FROM authors WHERE au_id = @param) = 'CA'
RETURN 1
ELSE
RETURN 2
چرا یه جا از Return و یه جا از Select استفاده میکنیم ؟!!