تبلیغات
SQL - درج دسته ای اطلاعات :

درج دسته ای اطلاعات :

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

درج دسته ای اطلاعات : در این قسمت می خواهیم با استفاده از جدول Student  به جدول Stubk مقادیر بدهیم.

ساختار اصلی:

INSERT INTO <table_or_view

<column_ list>

        <SELECT-Statement>

 

INSERT INTO  Stubk

       (SID,FName,LName)

SELECT

    ID

    FirstName

    LastName

FROm

           Student

       

نکته: تعداد ستون هایی که شما در این دستور SELECT می کنید باید با دستور بالایی برابر باشد.

نوع ستون هایی که شما SELECT می کنید باید با نوع  ستونهایی که در این دستور اوردید باید نظیر به نظیر برابر باشد.

مثال:

 

INSERT INTO  Stubk

   (SID,FName.LName)

SELECT

             ID

             firstName

             LastName

FROM

            dbo.Student

Stubk

 

LName

FName

SID

Bandpey

Mahla

1

Baghery

Samira

2

Panahi

Sara

3

 

 

 

 

 

Student

 

Last Name       

First Name

ID

Bandpey

Mahla

1

Baghery

Samira

2

Panahi

Sara

3

 

 

 

 

 



داغ کن - کلوب دات کام
نظرات() 
hack para cam4 2016
دوشنبه 16 بهمن 1396 06:12 ب.ظ
من بیشتر خوشحالم که این سایت را کشف کردم.

من می خواستم از آن زمان برای این خواندن فوق العاده تشکر کنم.
من قطعا از هر بخش از آن لذت می برم و همچنین شما را برای نشان دادن اطلاعات جدید در سایت خود به شما نشان می دهد.
Hiram
جمعه 17 آذر 1396 12:46 ق.ظ
Just desire to say your article is as astonishing.
The clarity to your submit is just excellent and that i can think you are knowledgeable on this subject.
Well with your permission allow me to grasp your feed to stay updated with approaching post.
Thank you one million and please carry on the rewarding work.
chaturbatefreetokenshack.com
دوشنبه 13 شهریور 1396 04:03 ق.ظ
If you wish for to get a good deal from this paragraph then you have to apply such
techniques to your won webpage.
regeniaosbon.soup.io
سه شنبه 24 مرداد 1396 09:13 ق.ظ
Because the admin of this website is working, no
doubt very quickly it will be famous, due to its feature
contents.
Tessa
سه شنبه 17 مرداد 1396 12:15 ق.ظ
It's hard to come by knowledgeable people about this subject, but you sound like you know what you're talking about!
Thanks
adenasaadat.blog.fc2.com
سه شنبه 2 خرداد 1396 05:19 ق.ظ
Hello mates, nice post and nice arguments commented here, I am in fact enjoying by these.
manicure
سه شنبه 5 اردیبهشت 1396 02:26 ب.ظ
Hello! I could have sworn I've been to this website before but
after going through some of the posts I realized it's new to me.
Anyways, I'm definitely delighted I discovered it and I'll be bookmarking it and checking back frequently!
manicure
یکشنبه 3 اردیبهشت 1396 02:24 ق.ظ
My partner and I absolutely love your blog and find the majority
of your post's to be just what I'm looking for. Would you offer guest writers to
write content for yourself? I wouldn't mind producing a post or elaborating on some of the subjects you write about here.
Again, awesome web log!
BHW
جمعه 1 اردیبهشت 1396 07:20 ب.ظ
Hi there! Would you mind if I share your blog with
my myspace group? There's a lot of folks that I think would really appreciate
your content. Please let me know. Thanks
manicure
یکشنبه 20 فروردین 1396 04:34 ب.ظ
Hello every one, here every one is sharing such experience, therefore it's good to read this website, and I used to visit this website all
the time.
 
لبخندناراحتچشمک
نیشخندبغلسوال
قلبخجالتزبان
ماچتعجبعصبانی
عینکشیطانگریه
خندهقهقههخداحافظ
سبزقهرهورا
دستگلتفکر




Admin Logo
themebox Logo