전문 번역가, 번역 회사, 웹 페이지 및 자유롭게 사용할 수 있는 번역 저장소 등을 활용합니다.
??? ??????? ????????? ??????????, ??????????? ?????? ???????, ??????????, ?????? ???????????? ?? ??? ?????????? ???? ??????????, ????? ????? ?????????? ??????????? ?? ?????????????????? ?????????? ???? ??????. sql server ???????????? ?????????? ?????? ????? ??????????, ??????????? ?????????, ????????? ?????????? ????????? ?????????? ?????? ????? ? ??????? ?? ??????? ?????????? ?????? ??????. ?? ????? ????????, ??? ????? ?????????? ?????????? ????? ???????? ????????. ????????, ???? ?????????? ????? ??????????? ??? ??????? ? ?????????????? ?????? ?????? ?????????? ? ???.
declare @sariya hierarchyid select @sariya = orgnode from employee where employeeid = 46 select empname, title, salary, orgnode.tostring() as 'orgnode' from employee where orgnode.getancestor(1) = @sariya go --results --empname title salary orgnode --------- --------- ------- ------- --wanida assistant 8000.00 /1/1/ ???? ?????? ?????????? ????? hierarchyid getancestor, ??????? ?????????? ???????????? ???? ???????? ???? hierarchyid. ? ??????????? ????, ?????????? @sariya ??????????? ?? ???? ???????? ?????. ??? ?????????? ??????, ??? ????? ? ?????? ???????? ?????? ??????????, ??????????????? ????? ???. ??????? ??????, ???????????? ???????????, ?????????????? ????? ????? ??????, ?????? ???????? ?? ????????? ?? ???? ?? ??????, ? ????? ?????? ???? ???????????, ??? ??????? ????-?????? ? ??? ???? ?????.