22,209
社区成员
发帖
与我相关
我的任务
分享
CREATE PROC [dbo].[SearchBillDetail]
(
@OpBeginDate DATETIME ,
@OpEndDate DATETIME ,
@BillTypeID INT ,
@BillOperType INT ,
@SaleOperID INT = 1,
@DrCompID INT = NULL
)
AS
SET NOCOUNT ON
-- 后面省略
SELECT *
FROM sys.parameters
WHERE object_id = OBJECT_ID('SearchBillDetail')
EXEC sp_procedure_params_rowset @procedure_name = 'SearchBillDetail'
SELECT *
FROM syscolumns
WHERE id = OBJECT_ID('SearchBillDetail')