ALTER PROCEDURE [dbo].[get_board] 
@code  int,
@num  int
AS
declare @p_code int
declare @p_num int
declare @n_code int
declare @n_num int
set nocount on
select top 1 @p_code=code,@p_num=num  from board where (code=@code and num>@num) or (code>@code)  order by code asc ,num desc
select top 1 @n_code=code,@n_num=num from board where (code=@code and num<@num ) or (code<@code) order by code desc, num desc
update board set  Cnt = cnt+1 WHERE code=@code and  num=@num
Select  top 1
seq,
name,
title,
cnt,
convert(char(16),indate,120),passwd,user_ip,
isnull(@p_code,-1),isnull(@p_num,-1),isnull(@n_code,-1),isnull(@n_num,-1),
content 
from board where code=@code and num=@num
set nocount off

CREATE  FUNCTION dbo.getDateFormat(@p_brand varchar(64), @p_fieldName varchar(64), @p_value datetime)
 RETURNS VARCHAR(4000)
AS
BEGIN
	declare @val varchar(4000)
	declare @format varchar(4000)
	declare @sql varchar(4000)

	set @format=
		(SELECT top 1 TRAN_VALUE 
		  FROM TB_MEMBER_CODETRAN 
		 WHERE BRAND=@p_brand 
			   AND FIELD_NAME=@p_fieldName 
		)
		
	if @format='date' begin
		set @val = (select @p_value)
	end 
	else begin
		set @val = (select dbo.FNDateFormat(convert(varchar(23),@p_value,121),@format))
	end
	return @val
END

UPDATE user set password=password("test2022ccw") where user = 'root';
commit

flush privileges;