USP_RECORDOPERATION_SMARTFIELDREMOVEFROMWAREHOUSE
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | |
| @CHANGEAGENTID | uniqueidentifier | IN | |
| @OLAPDATASOURCEID | uniqueidentifier | IN |
Definition
Copy
create procedure dbo.USP_RECORDOPERATION_SMARTFIELDREMOVEFROMWAREHOUSE
(
@ID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier,
@OLAPDATASOURCEID uniqueidentifier
)
as
set nocount on;
delete from dbo.[OLAPDATASOURCESMARTFIELD]
where
[OLAPDATASOURCEID] = @OLAPDATASOURCEID
and
[SMARTFIELDID] = @ID
return 0;