تبلیغات
SQL - دستور AS:

دستور AS:

نویسنده :tamishan tamishan1
تاریخ:سه شنبه 23 آبان 1391-12:34 ق.ظ

با استفاده از این دستور می توان برای ستون مورد نظر نام گذاشت.

مثال :

 

 

SELECT

     ID    AS  Code ,

     FirstName + '    ' + LastName   AS  FullName

FROM

    Student

 

FullName

Code

 

Mahla    Bandpey     

1

1

 

Samira    Baghery     

2

2

 

Sara   Panahi        

3

3

 

Mona   Salimi         

4

4

 

Ali   Alavi           

5

5

 

در این مثال می توانیم ستون ID را باز با همان مقدار در کنار ستون Code بیاوریم.

*   یادآوری: می توان نام ستون ها را به فارسی نوشت.

دستور * : همه اطلاعات جدول Student را به ما نشان می دهد.




داغ کن - کلوب دات کام
نظرات() 
кредит онлайн без верификации
شنبه 22 اردیبهشت 1397 05:13 ق.ظ
займ без фото
деньги в кредит онлайн на карту украина
кредит с плохой историей на карту
где быстро взять деньги украина
займ без отказа на карту
онлайн кредит на карту 24/7
кредит на карту без отказа срочно
upowex фитнес резинки
سه شنبه 11 اردیبهشت 1397 01:24 ب.ظ
фитнес резинки купить харьков
где в киеве купить фитнес резинки
эспандер резинка для фитнеса для подростка для рук
резинк жля фитнеса
резинка для фитнеса купить одесса
http://dtx-3.world-top-goods-2018.com
دوشنبه 10 اردیبهشت 1397 03:34 ب.ظ
DTX-3 - ВЫВОДИТ ПАРАЗИТОВ И ЗАЩИЩАЕТ ОТ ПОВТОРНОГО ЗАРАЖЕНИЯ ЗА ОДИН КУРС!
How do you stretch your Achilles?
شنبه 1 مهر 1396 06:09 ب.ظ
It's perfect time to make some plans for the long run and
it is time to be happy. I have learn this post and
if I may I wish to counsel you few interesting issues or suggestions.

Perhaps you could write next articles regarding this
article. I want to read even more things about it!
What is limb lengthening surgery?
دوشنبه 30 مرداد 1396 08:29 ق.ظ
Fine way of describing, and pleasant article to
obtain information regarding my presentation subject, which i am going to convey
in college.
emileeberg.hatenablog.com
سه شنبه 24 مرداد 1396 09:37 ق.ظ
Hello there! Would you mind if I share your blog with my myspace group?
There's a lot of people that I think would really enjoy your content.
Please let me know. Many thanks
Brodie
یکشنبه 4 تیر 1396 09:56 ق.ظ
Hi i am kavin, its my first occasion to commenting anyplace,
when i read this article i thought i could also make comment due to this brilliant paragraph.
http://aboundingsermon01.exteen.com
چهارشنبه 20 اردیبهشت 1396 03:44 ب.ظ
Hiya very nice site!! Guy .. Beautiful .. Amazing .. I'll bookmark your blog and take the feeds also?
I'm glad to find numerous useful info here
in the post, we want work out more strategies in this regard, thanks for sharing.
. . . . .
BHW
جمعه 25 فروردین 1396 06:41 ق.ظ
Hello there, just became alert to your blog through Google,
and found that it is truly informative. I am gonna watch out for brussels.

I will be grateful if you continue this in future. A lot
of people will be benefited from your writing.

Cheers!
manicure
یکشنبه 20 فروردین 1396 05:03 ق.ظ
I visit everyday some sites and websites to read articles, however this weblog presents feature
based writing.
 
لبخندناراحتچشمک
نیشخندبغلسوال
قلبخجالتزبان
ماچتعجبعصبانی
عینکشیطانگریه
خندهقهقههخداحافظ
سبزقهرهورا
دستگلتفکر




Admin Logo
themebox Logo