Creating SQL Stored Procedures via SQL Server is easier than you might have originally thought, so let us explain what to do.

SQL Server supports atomic blocks only at the top-level of natively compiled stored procedures. Every natively compiled stored procedure contains exactly one block of Transact-SQL statements.

Processing occurs one at a time and calls a SQL Server stored procedure. The SPROC is recursive. For each ID that is submitted, it can have any number of child ID's.

Now, with a few advanced stored-procedure debuggers on the market, the quality of discussion in these finger-pointing games may improve. Tools such as Compuware Corp.'s DevPartner DB for Microsoft SQL ...

While my code worked in every version of SQL Server, it was hardly "hip and happening." But, if you're using any version of SQL Server later than SQL Server 2005, you have an alternative: table-valued ...

SQL Server Stored Procedures A while back I wrote about the upcoming SQL Server Stored Procedure feature, but now it is fully available within Power Apps.

Tony Patton discusses the merits of stored procedures versus placing SQL directly in the code. Find out which one is best for your particular situation.

SQL Server 2000: Recursive Stored Procedure for Parent-Child relationship TheDan666 Sep 13, 2004 Jump to latest Follow Reply ...