(Troy Coleman) In the early years dynamic SQL was never used in a production environment. There were several reasons for this, but the biggest was catalog contention. The locks held in any user’s dynamic ad hoc SQL statement could bring down a new version of a program being moved into production.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help