DỰ ÁN PHẦN MỀM QUẢN LÝ TÀI SẢN NGÂN HÀNG BẢN VIỆT

declare @p15 int

set @p15=0

exec sp_executesql N'EXEC @RETURN_VALUE = [dbo].[PL_MASTER_Search_New_V2] @P_PLAN_CODE = @p0, @p_PLAN_NAME = @p1, @P_YEAR = @p2, @P_COST_ID = @p3, @P_BRANCH_ID = @p4, @P_BRANCHLOGIN = @p5, @P_PLAN_TYPE_ID = @p6, @p_DEP_ID = @p7, @p_GOOD_NAME = @p8, @p_USER_LOGIN = @p9, @P_TOP = @p10, @P_LEVEL = @p11',N'@p0 nvarchar(4000),@p1 nvarchar(4000),@p2 nvarchar(4000),@p3 nvarchar(4000),@p4 nvarchar(4000),@p5 nvarchar(4000),@p6 nvarchar(4000),@p7 nvarchar(4000),@p8 nvarchar(4000),@p9 varchar(8000),@p10 int,@p11 varchar(8000),@RETURN_VALUE int output',@p0=NULL,@p1=NULL,@p2=N'2021',@p3=NULL,@p4=NULL,@p5=N'DV0001',@p6=NULL,@p7=N'DEP000000000052',@p8=N'',@p9='sontv1',@p10=200,@p11='UNIT',@RETURN_VALUE=@p15 output

select @p15

go

SELECT * FROM PL_MASTER WHERE BRANCH_ID ='DV0001' AND DEPT_ID ='DEP000000000052'

EXEC dbo.sp_generate_inserts @table_name = 'PAY_ENTRIES_POST', -- varchar(776)

@from = 'FROM PAY_ENTRIES_POST' -- varchar(800)00)