#output parameter

[guangyaw]

C# 參數傳遞入門

在函式呼叫的時候， 引數傳遞到參數的方法可用傳值或者傳址方式， 今天就來教大家關於 C# 參數傳遞入門 在函式結束可選擇 return 一個值或者不回傳值， 若今天需要回傳兩個以上值， 就可透過傳址呼叫來達成這個目的。 底下就以三種方式來示範參數傳遞的方式 call by value  (傳值呼叫)call by reference (傳址呼叫)Output parameter (傳出呼叫) 傳值呼叫僅需要在函式呼叫的時候， 將變數放置於呼叫的小括號中即可， 在函式中對這個值做任意改變， 都不會影響在原來呼叫環境的原始值， 可參照範例程式執行的結果， 而傳址呼叫在使用的時候， 需要視情況在宣告的時候加上 ref 或者 out 來表示， 前者為 call by reference， 後者為 Output…

View On WordPress

[varindersandhu-blog]

New Post has been published on Varinder Sandhu 's Blog

New Post has been published on http://www.varindersandhu.in/2011/11/17/sql-server-stored-procedure-with-output-parameters/

SQL Server - Stored Procedure with Output Parameters

In SQL Server, there are two ways with we can pass parameters to procedures.

INPut parameter

OUTPut parameter

INPut parameter

These types of parameters are used to send values to stored procedures.

OUTPut parameter

<!-- google_ad_client = "pub-2404605494811633"; google_alternate_color = "FFFFFF"; google_ad_width = 468; google_ad_height = 60; google_ad_format = "468x60_as"; google_ad_type = "text_image"; google_ad_channel =""; google_color_border = "FFFFFF"; google_color_link = "0000FF"; google_color_bg = "FFFFFF"; google_color_text = "000000"; google_color_url = "008000"; google_ui_features = "rc:6"; //-->

These types of parameters are used to get values from stored procedures. This is similar to a return type in functions.

In this post we will try to understand how stored procedure returns the parameter

Example

-- Create a table CREATE TABLE myTable ( ID INT Identity(1,1), Name VARCHAR(20) ) -- Now Create a Stored Procedure with the OUTPUT parameter CREATE PROCEDURE my_sp ( @name VARCHAR(20), @id_out INT OUTPUT ) AS BEGIN INSERT INTO myTable VALUES (@name) SELECT @id_out = Scope_Identity () END GO

  Stored Procedure with Output Parameters

Similarly, for the second row

Stored Procedure with Output Parameters

  Stored Procedure with Output Parameters

Similarly you can get values from stored procedures as you need or required. Hope this post helps you to understand the OUTPut parameters.

[osrpt]

PetaPoco Output Parameter

var ctx = new CustomDBDatabase(); var total = new SqlParameter("TotalCount", System.Data.SqlDbType.Int); total.Direction = System.Data.ParameterDirection.Output; var results = ctx.Query<DBEntity>("exec GetDBEntities @StartIndex, @MaxIndex, @TotalCount OUTPUT", new { StartIndex = start, MaxIndex = max, TotalCount = total}); int totalCount = (int)total.Value;