ICT58 [SQL] Basics of SQL Cursor [Learning Subject]Basics of SQL Cursor [Objectives]- Understadning concepts of SQL cursor- Learning grammar and commands related to SQLcursor- Being able to manipluate SQL cursor [Core knowledge]SQL cursor is similar to C pointer, indicating memory for data processing.Generally SQL restrives data from a query all at once but SQL cursor can visit each record and manipulate data. Key concepts of S.. 2025. 4. 15. [SQL] Creating a Test Head Blocker [Scenario]A mission given to me killing SQL head blocker automatically by running the process every hour.However, SQL head blocker randomly appears thus hard to test. Test head blocker needs to be created. [Objectives]Creating a test head blocker [Steps]- Go and run SSMS(SQL Server Management Studio) - Create four tabs and run below queries-- 세션 A는 트랜잭션을 시작한 후 커밋하지 않음use YTC_OPERATIONBEGIN TRAN;.. 2025. 4. 8. [D365] Setting up PCF Environment This will guide you how to set up PCF(Power app Component Framework) environment. [Prerequisite]Two applications are required for PCF environement set up1. Visual Studio Code with Power Platform Tools as extension2. Microsoft Power Platform CLIhttps://aka.ms/PowerAppsCLI 1. Run command prompt > create a folder in the c: drive 2. Move to the folder just created then run below command as to crea.. 2025. 1. 22. [D365] Command Button with Power FX This will guide you how to define a fuction of button with Power FX. For more detail about Power FX, please refer to the below link.Microsoft Power Fx 개요 - Power Platform | Microsoft Learn Microsoft Power Fx 개요 - Power PlatformPower Fx 언어 개요learn.microsoft.com [Hiding and Displaying a Button]Occationally, buttons with function need to be hidden or shown according to user data input. Let's hide .. 2025. 1. 16. 이전 1 2 3 4 ··· 15 다음 반응형
