CREATE proc ep_rpt_tax_depr_details_spv0100
--===============================================================================
-- Procedure: ep_rpt_tax_depr_details_spv0100
--
-- Purpose: main procedure for gathering details for tax depreciation reports.
--
-- Parameters:
-- @vPortfolioID varchar(20)
-- @vAssetType varchar(20)
-- @vMainSort varchar(20)
-- @vDetailSort varchar(20)
--
-- Returns: result set of details
--
--
-- If datawindows using stored procs ever support arguments then put these back and remove the
-- ep_sp_arguments table logic!
--(
--
--@vPortfolioID varchar(20),
--@vAssetType varchar(20),
--@vMainSort varchar(20),
--@vDetailSort varchar(20)
--
--)
--AS BEGINDeclare @vPortfolioID varchar(20),
@vAssetType varchar(20),
@vMainSort varchar(20),
@vDetailSort varchar(20) Select @vPortfolioID = sp_proc_arg1,
@vAssetType = sp_proc_arg2,
@vMainSort = sp_proc_arg3,
@vDetailSort = sp_proc_arg5
From ep_sp_arguments
Where sp_db_spid = @@spidDelete From ep_sp_arguments
Where sp_db_spid = @@spid请问@@spid 是什么参数,@@代表什么 。谢谢
返回当前用户进程的服务器进程标识符 (ID)。
示例
下面的示例返回当前用户进程的进程 ID、登录名和用户名。SELECT @@SPID AS 'ID', SYSTEM_USER AS 'Login Name', USER AS 'User Name'下面是结果集:ID Login Name User Name
----- ------------- -----------
11 sa dbo
thanks to all !