Project

General

Profile

CM_ACCOUNT_BYID.txt

Luc Tran Van, 03/24/2022 01:58 PM

 
1
ALTER PROC [dbo].[CM_ACCOUNT_BYID]
2
@p_ACC_NO VARCHAR(15) = NULL
3
AS
4
BEGIN
5
SELECT TOP 1 A.*
6
FROM CM_ACCOUNT A
7
WHERE A.ACC_NO = @p_ACC_NO OR A.ID = @p_ACC_NO
8
END