I am trying to make my big migration more self explaining and that’s why I need to add some comments to it. However, I tried a few approaches and haven’t succeeded with them. I tried: // # <!– TEXT –> Error: Is there a way I can add a comment to flyway SQL migration? Answer The following should work on
Tag: comments
SQL/Regex Challenge/Puzzle: How to remove comments from SQL code (by using SQL query)?
Requirements Single-lines comments (e.g. — my comment) should be removed. Multi-line comments (e.g. /* my comment */) should be removed. The content of strings literals (e.g. ‘this is a multi-line comment: /* my comment */’) should be ignored. The content of identifiers (e.g. “– column 1 –“) should be ignored. literals and identifiers Literals and identifiers can span over multiple
How do you leave comments in SQL Server 2008 R2 view with SSMS?
According to multiple sources Microsoft , SQL Server Administration Blog | zarez.net adding comments to SQL and doing so with SSMS is a piece of cake. And for the most part they are probably right. But when I log in and create a view I have been unable to leave comments in it. If I use two hyphens (–) the
Are there multiline comment delimiters in SQL that are vendor-agnostic?
While editing, building up, or cherry picking from SQL statements I can find myself interacting with one of four popular database tools. I have been resorting to single line commenting for DB2 and Informix. I have created macros in Vim to make this slightly more efficient, but I was wondering if I am working too hard. Answer C style comments