تبلیغات
SQL - مثال:

مثال:

نویسنده :tamishan tamishan1
تاریخ:چهارشنبه 15 آذر 1391-12:19 ق.ظ

در مثال بالا به جای user ID (Fname,Lname) را به ما نشان دهد.(كه در Fname,Lnameانها حرف a باشد)

Alter   PROCEDURE  GetStudentInfo

             @Fname   nvarchar(50),

             @Lname   nvarchar(50)

AS

       SELECT

                         *

       FROM

                      Student

       WHERE

                     {Firstname  LIKE   '%' + @Fname  + '%'}  AND

                     {lastname  LIKE   '%' + @Lname  + '%'}

     EXEC  GetStudentInfo  'a' , 'a'

City ID

Last Name

First Name

Age

ID

10

Bandpey

Mahla

21

1

 

 نكته: هر بار كه شما با EXEC یك Stored Procedure را اجرا می كنید در قسمت Message (1  RoWs  affected) را نشان می دهد ولی با دستور SET  NOCOUNT ON این متن نشان داده نمی شود.

 




داغ کن - کلوب دات کام
نظرات() 
How do I stretch my Achilles tendon?
دوشنبه 30 مرداد 1396 02:20 ب.ظ
We're a bunch of volunteers and opening a new scheme in our community.
Your web site provided us with valuable info to work
on. You have performed an impressive activity and our entire
group can be thankful to you.
overtmaverick7257.wordpress.com
سه شنبه 24 مرداد 1396 01:18 ب.ظ
May I simply just say what a relief to find someone that truly understands what they're discussing online.

You actually realize how to bring a problem to light and
make it important. More and more people must read this and understand this side of the story.
I was surprised that you aren't more popular because you certainly
possess the gift.
How you can increase your height?
یکشنبه 15 مرداد 1396 08:15 ب.ظ
Spot on with this write-up, I absolutely believe this amazing site needs a lot
more attention. I'll probably be back again to see more, thanks for
the advice!
http://EmelineHollinger.bravesites.com/entries/general/Hammer-Toe-Causes
سه شنبه 2 خرداد 1396 10:05 ب.ظ
Awesome post.
manicure
یکشنبه 20 فروردین 1396 05:28 ق.ظ
Do you have any video of that? I'd want to find out some additional
information.
 
لبخندناراحتچشمک
نیشخندبغلسوال
قلبخجالتزبان
ماچتعجبعصبانی
عینکشیطانگریه
خندهقهقههخداحافظ
سبزقهرهورا
دستگلتفکر




Admin Logo
themebox Logo