Script Library This section will highlight various scripts in SQL, and eventually in R. These are scripts that I often use but can be challenging to remember the specifc syntax. SQL Scripts Featured Common Table Expression Dynamic SQL- EXEC() Dynamic SQL: SP_EXECUTESQL Row_Number() Cursor