USE [Brunei-eCustomsDEV]
GO
dbcc freeproccache
go--clear the cache in sql server
set statistics profile on
set statistics time on
set statistics io on
go
DECLARE @return_value int,
@p_total_count int
EXEC @return_value = [dbo].[P_BC_LIS_LIQUOR_INFOR_S]
@p_liq_import_ref_no = NULL,
@p_passenger_name = 'xiong1',
@p_passenger_dob = NULL,
@p_passport_no = NULL,
@p_location = NULL,
@p_date_arri_from = NULL,
@p_date_arri_to = NULL,
@p_start_row_index = NULL,
@p_maximum_rows = NULL,
@p_total_count = @p_total_count OUTPUT,
@p_sort_expression = NULL
SELECT @p_total_count as N'@p_total_count'
SELECT 'Return Value' = @return_value
GO
set statistics profile off
set statistics time off
set statistics io off
go