تبلیغات
SQL - نکته 2:

نکته 2:

نویسنده :tamishan tamishan1
تاریخ:دوشنبه 6 آذر 1391-06:14 ب.ظ

نکته : اگر ما برای جدول CityInfo در قسمت   Default CityName مقدار NoCity  را انتخاب کنیم  ،در صورتیکه به Cityname مقداری ندهیم مقدار پیش فرض را انتخاب می کند.

 

مثال :

INSERT INTO CityInfo

  (Population,state)

VALUES (125000 , N'Qom' )

SELECT

      *

FROM

                                                                                                                                                           CityInfo       

State

Population

CityName

CID

Tehrsn

520000

Tehran

10

Sari

145000

Sari

20

Sari

120000

Behshahr

30

Hamedan

320000

Ahvaz

40

Tehran

410000

Tehran

50

Qom

125000

Kashan

60

Qom

125000

NOCity

70

      




داغ کن - کلوب دات کام
نظرات() 
http://judecarter.hatenablog.com/entry/2016/02/24/001041
سه شنبه 24 مرداد 1396 11:50 ق.ظ
Wow! This blog looks just like my old one! It's on a totally different subject but it
has pretty much the same layout and design. Wonderful choice of colors!
What causes the heels of your feet to burn?
یکشنبه 15 مرداد 1396 11:33 ب.ظ
I couldn't refrain from commenting. Perfectly written!
tomokoharoun.hatenablog.com
شنبه 14 مرداد 1396 09:04 ق.ظ
Wow, this paragraph is fastidious, my sister is analyzing these things, thus I am going to tell her.
manicure
جمعه 8 اردیبهشت 1396 10:21 ب.ظ
Definitely consider that which you said. Your favourite reason seemed to be
at the net the simplest thing to take into accout of.
I say to you, I certainly get irked while other people think about worries that
they plainly don't recognise about. You managed to hit the nail upon the highest
and outlined out the whole thing with no need side-effects
, folks can take a signal. Will probably be again to get more.
Thank you
manicure
یکشنبه 20 فروردین 1396 03:44 ب.ظ
Thanks for ones marvelous posting! I truly enjoyed reading
it, you will be a great author. I will be sure to bookmark
your blog and may come back in the foreseeable
future. I want to encourage you to continue your great posts, have a nice evening!
 
لبخندناراحتچشمک
نیشخندبغلسوال
قلبخجالتزبان
ماچتعجبعصبانی
عینکشیطانگریه
خندهقهقههخداحافظ
سبزقهرهورا
دستگلتفکر




Admin Logo
themebox Logo