This website uses cookies to ensure you get the best experience.
Learn more.
A developer defines a CTE before a SELECT and expects it to remain available to unrelated later statements. What should be clarified?
Published
- A CTE is scoped to the associated statement rather than being a persistent table
- CTE naming determines backup retention
- Every CTE automatically creates a permanent database table
- A CTE grants all users access to the source
Comments — 0
Sign in to comment