Description
Properties
| Name | Value |
|---|---|
| ANSI Nulls ON | True |
| Quoted Identifier ON | True |
| Encrypted | False |
| Execute As | |
| Assembly |
Parameters
| Name | Data Type | Length | Description |
|---|---|---|---|
| @idbc271hdr | bigint | 8 | |
| @userid | varchar | 10 | |
| @noajubc271 | varchar | 20 | |
| @tgajubc271 | date | 3 | |
| @nobc271 | varchar | 20 | |
| @tglbc271 | date | 3 |
SQL Script
SET QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
CREATE PROCEDURE dbo.spu_updatenobc271
(@idbc271hdr as bigint,@userid varchar(10), @noajubc271 varchar(20), @tgajubc271 date, @nobc271 varchar(20), @tglbc271 date)
AS
BEGIN
declare @now datetime
set @now = GETDATE()
UPDATE tbl_bc_in_hdr set CAR=@noajubc271, DokTupTg=@tgajubc271
,BC23No=@nobc271
,BC23Tg=@tglbc271
,statusdok='DATA PROCESSED'
,update_date=@now
,update_by=@userid
where id_bc_in_hdr = @idbc271hdr
select '00' as status, ' Sukses'+' :Data Updated' as description
END
--go
--exec(' spu_updatenobc271 @idbc271hdr=2,@userid=''admin'', @noajubc271=''20130422000009'', @tgajubc271=''04/22/2013'', @nobc271=''992992'', @tglbc271=''04/22/2013'' ')
GO
GO
CREATE PROCEDURE dbo.spu_updatenobc271
(@idbc271hdr as bigint,@userid varchar(10), @noajubc271 varchar(20), @tgajubc271 date, @nobc271 varchar(20), @tglbc271 date)
AS
BEGIN
declare @now datetime
set @now = GETDATE()
UPDATE tbl_bc_in_hdr set CAR=@noajubc271, DokTupTg=@tgajubc271
,BC23No=@nobc271
,BC23Tg=@tglbc271
,statusdok='DATA PROCESSED'
,update_date=@now
,update_by=@userid
where id_bc_in_hdr = @idbc271hdr
select '00' as status, ' Sukses'+' :Data Updated' as description
END
--go
--exec(' spu_updatenobc271 @idbc271hdr=2,@userid=''admin'', @noajubc271=''20130422000009'', @tgajubc271=''04/22/2013'', @nobc271=''992992'', @tglbc271=''04/22/2013'' ')
GO
Depends On
1Used By
No items found