تبلیغات
SQL - ساخت Stored Procedure

ساخت Stored Procedure

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

CREATE  PROCEDURE   GetuserFullname

                       @userID    int,

                       @Fullname   nvarchar(5)    output

 

AS

               SET  NOCOUNT    N;

SELECT   Fullname=

                            (firstname +'      '+lastname)

 FROM

                                   Student

WHERE

              ID=  @userID

DECLARE     @fn   nvarchar(100)

Firstname,Lastname كسی كه ID ان 5 هست را در متغیر FN می كذارد.

EXEC  GetuserFullname  5,@fn  output

Print   @fn

 




داغ کن - کلوب دات کام
نظرات() 
How we can increase our height?
دوشنبه 30 مرداد 1396 04:25 ب.ظ
Thanks very interesting blog!
http://kareytraywick.hatenablog.com/archive/2015/09/29
سه شنبه 24 مرداد 1396 11:18 ق.ظ
Right now it sounds like Expression Engine is the preferred blogging platform out there right now.
(from what I've read) Is that what you're using on your blog?
How do you treat Achilles tendonitis?
یکشنبه 15 مرداد 1396 09:17 ب.ظ
Hey there! This is my first visit to your blog!
We are a team of volunteers and starting a new initiative in a community in the same niche.

Your blog provided us useful information to work on. You have done a wonderful job!
manicure
جمعه 8 اردیبهشت 1396 09:28 ب.ظ
You actually make it appear really easy together with your presentation but I find this matter to
be really one thing that I believe I might by
no means understand. It seems too complicated and extremely large for me.

I am having a look forward in your next publish,
I'll attempt to get the hang of it!
manicure
شنبه 2 اردیبهشت 1396 10:41 ب.ظ
I know this web page presents quality based content and extra stuff, is there any other website which presents such stuff in quality?
manicure
شنبه 19 فروردین 1396 11:34 ب.ظ
Pretty! This was an extremely wonderful article. Many thanks for supplying this information.
 
لبخندناراحتچشمک
نیشخندبغلسوال
قلبخجالتزبان
ماچتعجبعصبانی
عینکشیطانگریه
خندهقهقههخداحافظ
سبزقهرهورا
دستگلتفکر




Admin Logo
themebox Logo