SQLServerCentral Article

Recursive Queries in SQL:1999 and SQL Server 2005

How many of you have written resursive queries in SQL? Or any language since school for that matter? Not many people write recusrive queries because of the complexity, the difficulty to understand how they work, and the chance for heap overflows. However, SQL Server 2005 implements Common Table Expressions and recursion in a way that is much easier to code and incorporates some safeguards. New author SQL Server MVP Frederic Brouard has written a fantastic article looking at resursive queries.

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

BCA KCP Mohamad Toha NO TELPON 087781685658

By Boomslotts

WHATSAPP 087781685658 Jl. Moch. Toha No.197, Cigereleng, Kec. Regol, Kota Bandung, Jawa Barat 40253

BCA KCP Sei Raya Dalam No.Telpon:083135765355

By CHERRYWIFARM- The Best CBD flowers Europe - Wholesale Hemp Flowers Europe

Whatsapp:083135765355 Jl. Sungai Raya Dalam No.004, RT.001, Sungai Raya, Kec. Sungai Raya, Kabupaten Kubu...

Alamat kontak resmi BCA KCU AMBON | Telp: 0817825533

By link1408

phone, Wa: 0817825533, Jl. Sultan Hairun No.24, Kel Honipopu, Kec. Sirimau, Kota Ambon, Maluku...

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