SQL4 [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. [SQL] Procedure for Creating a New Account in Canteen System [Requirements] - SQL a procedure creating a new account in canteen system [OS] Windows Server 2021 R2 [Development Language] SQL [IDE] SSMS(SQL Server Management Studio) [Setting] - [Code] USE [YTC_OPERATION] GO /****** Object: StoredProcedure [dbo].[CREATE_USER] Script Date: 2024-03-04 오후 4:27:08 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[CREATE_USER](@name .. 2024. 3. 4. [VBA] Extracting Data from SQL with a Button in Excel [Requirements] Business transport team asks a Excel sheet to fetch all purchase order data in ERP system - Create Excel file with VBA embedded which fetchs data - Create SQL procedure calling ERP data from SQL database [OS] Windows 10 [Development Language] VBA, SQL [IDE] SSMS(SQL Server Management Studio), Microsoft Visual Basic For Applications [Code] VBA script: GetData_from_SQLServerDatabase.. 2023. 6. 27. 이전 1 다음 반응형
