I have a table in my PieCloudDB Database that stores daily sales (Some dates may not have data), and I now want to calculate the daily sales growth percentage for consecutive dates.

I am looking for a way to test if a SQL script will execute on a database without actually executing the script or having permission to execute the script. The reason for this is that my team writes code for a SQL database and we maintain that code in a DevOps repository. When we deploy changes to the database we create a SQL script and then provide that script to a DBA to run with db_owner permissions. Occasionally, we run into a situation where there is an error in the script and the script fails to execute when run by the DBA.

I´m not sure if this belongs here, but I would really appreciate your help.

can I make a cardNumber a transitive dependency? or should I keep it? (note that this is only a school project, there’s no personal data here)