External Article

Using Dynamic SQL in Stored Procedures

Dynamic SQL allows stored procedures to “write” or dynamically generate their SQL statements. The most common use case for dynamic SQL is stored procedures with optional parameters in the WHERE clause. These are typically called from reports or screens that have multiple, optional search criteria. This article describes how to write these types of stored procedures so they execute well and resist SQL injection attacks.

Blogs

T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?

By

It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...

Understanding Fabric MCP

By

Model Context Protocol, or MCP, is one of those technical ideas that sounds more...

AWS RDS Aurora - our first approach

By

When starting with AWS RDS Aurora for managing relational databases in the cloud, many...

Read the latest Blogs

Forums

ATM BCA KCP Plaza Medan Fair TLP/WA 0821•697•7749

By ilmihouse1

HMV7+946, Sekip, Kec. Medan Petisah, Kota Medan, Sumatera Utara 20111

BCA Multifinance Cabang Kedoya Hub.0851•8812•0691

By jpnorman

BCA Multifinance Cabang Kedoya Hub.0851•8812•0691 Citta Graha, Jl. Panjang, RT.5/RW.1, South Kedoya, Kebonjeruk, West...

BCA Finance Kelapa Gading Layanan Mobil Hub.0851•8812•0691

By jpnorman

BCA Finance Kelapa Gading Layanan Mobil Hub.0851•8812•0691 Ruko Mall Of Indonesia Blok B 32-33,...

Visit the forum

Question of the Day

May the Fourth Be With You Fun

In honor of May the fourth and Star Wars (may the force be with you), finish this quote:

"Do, or do not.  ..."

See possible answers