Search
-
Does Flyway support Jinja template if-else-endif syntax?
Hi, I tried to run SQL statement for specific environment by using Jinja template if-else-endif syntax. -- {% if '${env}' = 'stg' %}grant test_role to test_user;{% endif %} -- but it failed with syntax error. -- SQL State : 42601 Error Code : 0Message : ERROR: syntax error at or near "{" Position: 1Line : 4 Statement : {%… -
Re: Drop schema being included in table create script
-
Re: Executing SqlDataCompare from anExecute Process task in SSIS
Comment by david connell · · Home› Discontinued and Previous Versions› SQL Toolkit Previous VersionsHi Al, I don't know if you could use a batch file to go wrap up the program. Similar to this call SqlDataCompare.exe %1 %2 if errorlevel 64 goto endif errorlevel 63 goto allOKgoto end:allOKexit /B 0:end@echo Errror level set to %errorLevel%exit /B errorLevel Hope that helps David -
Re: DEFECT 5.3.2: Table Variable not prompted
Comment by Chris Auckland · · Home› Discontinued and Previous Versions› SQL Prompt Previous VersionsThanks for your post. I've haven't been able to reproduce this in a test case, so would you be able to post an example that reproduces this? I've tried the following, which prompted me for @Meter at the <cursor> DECLARE @Meter TABLE (id INT, text VARCHAR(30))DECLARE @Upper int;DECLARE @Lower intSET @Lower = 1SET @Upper =… -
Backup to individual folders
Discussion by Brian Donahue · · Home› Discontinued and Previous Versions› SQL Backup Previous VersionsHere is another script that you can use in a SQL Server job to backup databases using SQL Backup. This script uses COM automation to create a separate folder for each database to keep things better-organized. This can easily be modified to backup logs on a schedule by changing the @backupstring variable. set nocount on /*… -
stored proc for removing old backups inside
I wrote this stored proc to remove all old backups, keeping only what's needed for one full restore... we have pretty tight space limitations, due to the size of some of the databases we run, and SQL Backup's built-in ERASEFILES option isn't too smart (can remove all full's when ran with a diff for example)... Hopefully… -
Re: asp.net profile: not understanding where the time is spent
Comment by adbourdages · · Home› Discontinued and Previous Versions› ANTS Performance Profiler Previous VersionsAll right, lots of info here. First, about the ThreadStart, there no data in there. I did a graph of the execution tree and it didn't show anything useful: http://71.6.196.213:82/ForRedGate/threadstart.png Second, concerning the suspicious dip in CPU usage. It is pretty simple: that is when the web server passes the SQL…
7 results