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

دستور TRUNCATE TABLE :

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

 

دستور TRUNCATE  TABLE : سطرهای جدول را پاک می کند. این دستور شرط قبول نمی کند.تنظیمات جدول را RESET می کند.

ساختار اصلی دستور TRUNCATE  :

TRUNCATE TABLE <table_name>

 

مثال :

همه اطلاعات جدول را پاک کرد.                              TRUNCATE TABLE CityInfo                                                                                  

 

                                  INSERT INTO CityInfo

یک سطر درج کرد        (CityName,Population,State)                   

VALUES    (N'Kashan',125000,N'Qom')

SELECT

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

FROM

  CityInfo

Qom

125000

Kashan

10

 

نکته: فرق دستور DELETE  با TRUNCATE  دراین است که در دستور DELETE می توان اطلاعات را برگرداند ولی در دستور TRUNCATE نمی توان چنین عملی انجام داد.

   




داغ کن - کلوب دات کام
نظرات() 
Celuraid Muscle Bezugsquelle
دوشنبه 9 اردیبهشت 1398 03:11 ب.ظ
Just wish to say your article is as surprising.
The clarity in your post is simply spectacular and i can assume
you are an expert on this subject. Well with your permission allow me to grab your feed to
keep up to date with forthcoming post. Thanks a million and please keep up the
gratifying work.
http://www.allfresco.ru/molnieotvod
پنجشنبه 5 اردیبهشت 1398 05:44 ق.ظ
シャネル スーパーコピーブランド 専門店
http://www.oumma.be/actualite
پنجشنبه 5 اردیبهشت 1398 05:42 ق.ظ
コピーブランド通販店で一番信用のある店なので、お届いた商品は絶対にサイトに掲載した写真と同じで、お客様の個人情報の
http://musafir.org/take-part
شنبه 31 فروردین 1398 01:42 ب.ظ
オメガスーパーコピーN級品偽物、本物品質時計オメガ時計コピー海外激安通販専門店
http://old-2014.rsu.edu.ru/theatre
شنبه 31 فروردین 1398 01:40 ب.ظ
楽天ブランドコピー 代引き激安市場/コピー 商品 販売
eron plus
پنجشنبه 22 فروردین 1398 09:30 ب.ظ
Good day! I know this is kind of off topic but I was wondering which blog
platform are you using for this site? I'm getting
tired of Wordpress because I've had problems with hackers and I'm looking at alternatives for another platform.
I would be great if you could point me in the direction of
a good platform.
http://tabletky-na-erekci-cz.eu/
پنجشنبه 22 فروردین 1398 06:29 ب.ظ
Thanks for your personal marvelous posting! I seriously enjoyed reading it, you will be a
great author.I will ensure that I bookmark your blog and will come back
from now on. I want to encourage that you continue
your great posts, have a nice afternoon!
pastillas naturales para la ereccion
سه شنبه 9 بهمن 1397 06:48 ب.ظ
The data is rather interesting.
tonus fortis
سه شنبه 9 بهمن 1397 02:34 ب.ظ
Exceptionally user friendly site. Huge info offered on couple of clicks.
Xtrasize
سه شنبه 9 بهمن 1397 12:49 ب.ظ
Incredible, such a important websites.
brave frontier cheats
جمعه 4 اسفند 1396 07:52 ب.ظ
چه اتفاقی افتاده است، همه چیز خوب پیش می رود و البته همه هم به اشتراک می گذارند
اطلاعات، این واقعا خوب است، نگه داشتن نوشتن.
laverneBallenger.jimdo.com
سه شنبه 24 مرداد 1396 12:11 ب.ظ
I simply couldn't leave your web site before suggesting that
I really loved the standard information a person provide for your visitors?
Is going to be again incessantly to investigate cross-check new posts
What do you do for Achilles tendonitis?
دوشنبه 16 مرداد 1396 02:31 ق.ظ
You made some good points there. I checked on the web to learn more about the issue and found most people will go along with your views
on this site.
http://holdenaxpqfwofih.jimdo.com
شنبه 14 مرداد 1396 11:04 ق.ظ
I always emailed this website post page to all my friends, because if like to read it afterward my friends will too.
manicure
یکشنبه 20 فروردین 1396 02:33 ق.ظ
You actually make it appear really easy along with your presentation however I to find this matter to
be actually one thing which I think I might by no means understand.

It sort of feels too complex and very large for me. I'm looking ahead for your subsequent submit,
I will attempt to get the cling of it!
 
لبخندناراحتچشمک
نیشخندبغلسوال
قلبخجالتزبان
ماچتعجبعصبانی
عینکشیطانگریه
خندهقهقههخداحافظ
سبزقهرهورا
دستگلتفکر




Admin Logo
themebox Logo