تبلیغات
SQL - استفاده از یك QUERY در توابع:

استفاده از یك QUERY در توابع:

نویسنده :tamishan tamishan1
تاریخ:چهارشنبه 15 آذر 1391-12:40 ق.ظ

این مثال ستونی به نام ضرب ایجاد می شود كه ستون های ID,Age را در هم ضرب میكند.

CREATE  FUNCTION  Mul

(

     @a int,

     @b int

)

RETURNS bigint

AS

BEGIN

          DECLARE @r  bigint

          SET  @r=@a*@b

                        RETURN @r

END

SELECT  DBO.Mul   (3,5)  AS   ZARB

SELECT

    ID,

    Firstname,

    Lastname,

Age   

DBO.Mul (ID,Age)  AS  ZARB

FROM

       Student    

 




داغ کن - کلوب دات کام
نظرات() 
http://walter7carson44.jimdo.com
پنجشنبه 29 تیر 1396 05:07 ب.ظ
If you desire to increase your know-how just keep visiting this site and be updated with the most up-to-date gossip posted here.
reillybsavnmluyr.soup.io
چهارشنبه 28 تیر 1396 06:15 ب.ظ
This post will help the internet people for building up new webpage or even a blog
from start to end.
mirnawardrup.wordpress.com
یکشنبه 25 تیر 1396 02:10 ب.ظ
Hello, Neat post. There's a problem with your website in internet explorer, may check this?

IE nonetheless is the market leader and a big portion of people will leave out
your fantastic writing because of this problem.
brad2frazier13.tumblr.com
یکشنبه 25 تیر 1396 02:45 ق.ظ
Hello would you mind stating which blog
platform you're working with? I'm planning to start my own blog in the near future but I'm
having a difficult time choosing between BlogEngine/Wordpress/B2evolution and Drupal.
The reason I ask is because your design seems different then most blogs and I'm looking for something unique.
P.S My apologies for being off-topic but I had to ask!
http://kristabrennick.blog.fc2.com/
شنبه 24 تیر 1396 10:09 ق.ظ
I am in fact glad to read this blog posts which contains lots of useful data, thanks for providing these information.
BHW
پنجشنبه 31 فروردین 1396 10:37 ب.ظ
Having read this I thought it was very informative.

I appreciate you spending some time and effort to put this information together.
I once again find myself spending a lot of time both reading and leaving comments.

But so what, it was still worthwhile!
 
لبخندناراحتچشمک
نیشخندبغلسوال
قلبخجالتزبان
ماچتعجبعصبانی
عینکشیطانگریه
خندهقهقههخداحافظ
سبزقهرهورا
دستگلتفکر




Admin Logo
themebox Logo