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

دستور UPDATE :

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

دستور UPDATE   :از این دستور برای ویرایش اطلاعات استفاده می شود.

UPDATE  <table_or_view>

  SET Column1=Value1[,Column2=Value2[,..]]

[

WHERE  <condition>

]

 

UPDATE  CityInfo مثال:

      SET Population =Population+100

            CityName=N'[ ' +CityName+ N '] ',

WHERE

  CID   BETWEEN  20 AND  40

SELECT

         *

FROM

    CityInfo

Sari

145100

Sari ]  [

20

Sari

120100

   [Behshahr]

30

Hamedan

320100

Ahvaz ] [

40




داغ کن - کلوب دات کام
نظرات() 
Can you have an operation to make you taller?
شنبه 1 مهر 1396 09:29 ب.ظ
Hello just wanted to give you a quick heads up and let you know a few of the pictures aren't
loading properly. I'm not sure why but I think its a linking issue.
I've tried it in two different internet browsers and both show the same outcome.
How do you treat a sore Achilles tendon?
یکشنبه 15 مرداد 1396 10:32 ب.ظ
This is really interesting, You're a very skilled blogger.
I have joined your rss feed and look forward to
seeking more of your excellent post. Also,
I have shared your site in my social networks!
What makes you grow taller during puberty?
یکشنبه 15 مرداد 1396 09:24 ب.ظ
I visited many sites but the audio feature for audio songs current at this
site is genuinely wonderful.
http://maximabronzo.hatenablog.com/entry/2017/07/01/001037
شنبه 31 تیر 1396 01:54 ب.ظ
I couldn't resist commenting. Very well
written!
Can you lose weight by doing yoga?
پنجشنبه 29 تیر 1396 06:14 ق.ظ
This site was... how do you say it? Relevant!! Finally I have found something which helped me.

Cheers!
foot pain at night
یکشنبه 4 تیر 1396 03:23 ب.ظ
Hello my friend! I want to say that this post is awesome, great written and include approximately all significant infos.
I would like to look more posts like this.
http://silvia1nieves27.over-blog.com/2015/06/hammer-toes-surgery.html
دوشنبه 1 خرداد 1396 02:48 ب.ظ
Wonderful beat ! I would like to apprentice whilst you amend your site, how could i subscribe for a blog website?

The account aided me a applicable deal. I had been tiny bit familiar of this
your broadcast offered brilliant clear concept
ellenfriese.hatenablog.com
شنبه 30 اردیبهشت 1396 08:16 ب.ظ
Hello i am kavin, its my first time to commenting anyplace, when i read this post i thought i could
also make comment due to this brilliant post.
manicure
پنجشنبه 7 اردیبهشت 1396 10:15 ب.ظ
I'm not certain where you are getting your info, however great topic.
I needs to spend some time studying much more or understanding more.
Thanks for wonderful info I used to be in search of this information for my mission.
BHW
جمعه 25 فروردین 1396 12:40 ق.ظ
Link exchange is nothing else however it is just placing the other person's
website link on your page at appropriate place and other person will also do same in favor
of you.
BHW
پنجشنبه 24 فروردین 1396 04:51 ق.ظ
Its like you read my mind! You appear to know
a lot about this, like you wrote the book in it or something.
I think that you can do with a few pics to drive
the message home a little bit, but instead of that, this is
fantastic blog. A fantastic read. I'll definitely be
back.
manicure
یکشنبه 20 فروردین 1396 07:49 ق.ظ
Saved as a favorite, I love your website!
 
لبخندناراحتچشمک
نیشخندبغلسوال
قلبخجالتزبان
ماچتعجبعصبانی
عینکشیطانگریه
خندهقهقههخداحافظ
سبزقهرهورا
دستگلتفکر




Admin Logo
themebox Logo