skills.rest
AUD-DEV-TEAM
AUD-DEV-TEAMCOMMUNITY
Explore all skills by this author →
GitHub

iaud-sql-guide

Define i-AUD DataSource SQL with parameter binding and dynamic scripting.

3|1|Updated Jun 12, 2025
Search Tags:#sql#data-source#procedures#parameter-binding#iaud#dynamic-sql#in-clauses
One-click install
npx skills add https://github.com/AUD-DEV-TEAM/i-AUD-Developer-Kit --skill iaud-sql-guide
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: iaud-sql-guide
Source: https://github.com/AUD-DEV-TEAM/i-AUD-Developer-Kit/tree/main/.claude/skills/iaud-sql-guide
Command: npx skills add https://github.com/AUD-DEV-TEAM/i-AUD-Developer-Kit --skill iaud-sql-guide

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

i-AUD DataSource SQL 작성에 필요한 파라미터 바인딩 규칙, 특수 지시자, IN절 처리, Dynamic SQL, 프로시저 호출 등을 명확하게 안내합니다. 이 가이드는 VS_/VN_ 접두사 규칙, 일반 파라미터 바인딩, 네이티브 세션 값 사용 방법 등을 정리하여 개발자의 SQL 작성 부담을 줄입니다.

Core Features & Use Cases

  • VS_/VN_ 접두사 및 일반 파라미터 바인딩 규칙과 값 감싸기/미감싸기 차이를 설명합니다.
  • 특수 지시자(@, %, $, ::)를 활용한 라인 제거, LIKE 매칭, 세션 값 강제 사용 등의 동적 제어를 제공합니다.
  • IN 절 처리, NVarchar 대응, 파일/데이터 소스 선택 방법 등을 포함한 데이터소스 수준의 규칙을 다룹니다.
  • 동적 SQL 작성은 <%% %> 및 <%= %> 구문으로 JavaScript 기반으로 SQL을 구성하는 방법을 제시합니다.
  • 프로시저 호출 형식, 주석 처리 규칙, PreparedStatement 바인딩으로 안전한 쿼리 생성을 안내합니다.

Quick Start

샘플 SQL에서 VS_/VN_ 파라미터 바인딩과 <% %> 동적 구문을 적용하여 최종 실행 쿼리를 생성해 보세요.

Frequently Asked Questions about iaud-sql-guide

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I bind parameters in i-AUD DataSource SQL queries?▼

i-AUD SQL parameter binding uses VS_ and VN_ prefixes to control value wrapping, alongside standard parameter binding for safe PreparedStatement query generation across report and data access layers.

What is dynamic SQL and how do I write it in i-AUD data sources?▼

Dynamic SQL in i-AUD data sources is constructed using JavaScript-based blocks with <%% %> and <%= %> syntax, allowing developers to conditionally build and format query strings at runtime.

How do I handle IN clauses and NVarchar types in i-AUD SQL?▼

IN clause handling and NVarchar type mapping in i-AUD SQL are managed through data-source level binding rules, ensuring proper parameter expansion and type conversion for safe query execution.

What are the special directives in i-AUD SQL and when should I use them?▼

Special directives in i-AUD SQL include @, %, $, and ::, used for dynamic line removal, LIKE matching patterns, forcing native session values, and controlling query generation safely.

Can I call stored procedures in i-AUD DataSource SQL?▼

Stored procedures can be called within i-AUD DataSource SQL by following specific procedure invocation formats and PreparedStatement binding rules, ensuring safe and formatted query generation.

Why are my VS_ and VN_ prefixed parameters not binding correctly in i-AUD?▼

VS_ and VN_ prefixed parameters may fail to bind correctly in i-AUD if the distinction between value wrapping and non-wrapping rules is misapplied, or if special directive syntax is improperly formatted.

Related Skills

Explore More Software Engineering Skills→
ortus-boxlangortus-boxlang

boxlang-database-access

Enforce parameterized queries and manage datasources in BoxLang.

Official
Advanced
weiflycc-cmdweiflycc-cmd

sqldw-consumption-cli

Execute read-only T-SQL queries against Microsoft Fabric SQL endpoints via CLI.

Community
Intermediate
AUD-DEV-TEAMAUD-DEV-TEAM
3

iaud-mtsd-create

Create and validate MTSD documents for i-AUD reports using MCP tools and UUID IDs.

Community
Advanced
marquesfelipmarquesfelip

sql-injection-prevention

Identify and fix SQL injection vulnerabilities in data access layers.

Community
Advanced