Settings and activity
18 results found
-
9 votes
An error occurred while saving the comment -
2 votes
An error occurred while saving the comment Thomas Franz commented
Better do NOT hardcode stuff in your table, better add a flag to your status code table that you can use in your query.
Maybe not today and tomorrow, but sometimes in the future you will have another similar exception and would either need to find every occurence of it in your code or simply set the flag on the new status.
-
1 vote
An error occurred while saving the comment You can create a snipped (e.g. in0) with the following content:
ISNULL($SELECTEDTEXT$, 0) AS [$SELECTEDTEXT$]In your code mark the column name, press (and release) the Ctrl-Key shortly and type in0 into the small popup menu to select the snippet (often i would be enough)
It would work well, if you have no table alias
SELECT ISNULL(name, 0) AS [name]
and not so well, if you have one (for this reasons I added the square brackets to not break the code, you may want to remove the alias the whole time)
SELECT ISNULL(o.name, 0) AS [o.name]As alternative you could use RegEx and the usual Replace dialog, which would allow you to do this for multiple columns at once
-
1 vote
An error occurred while saving the comment Shouldn't the auto completion suggests the person table as soon you are typing pe after a FROM / JOIN etc.?
And even if you have multiple pe%-tables, it is selflearning, so you just need to pick up the correct table once (per day / SSMS-restart) and it will be the top suggestion the next time.
-
16 votes
-
12 votes
-
4 votes
An error occurred while saving the comment doublet
-
7 votes
An error occurred while saving the comment you can already uncheck the Users in the Compare results (which would prevent them from being deployed too)
-
9 votes
-
71 votes
-
18 votes
An error occurred while saving the comment are 3.5 years enough wait time for a new context menu entry? Hoping to see it soon :-)
-
5 votes
-
10 votes
-
633 votes
Hi,
We just added this capability to Flyway, which is our x-database, x-OS cloud- and Git-first Database DevOps solution for versioning and deploying database changes. You can learn more about this feature in Flyway at https://documentation.red-gate.com/fd/working-with-data-138347109.html#Workingwithdata-Controllingstaticdata.
You can also import your SQL Source Control repos into Flyway while keeping your Git history. Learn more about moving to Flyway and importing your project at https://documentation.red-gate.com/fd/transitioning-from-other-redgate-tools-164167855.html.
If you have any questions, please comment below or reach out to us at DatabaseDevOps@red-gate.com.
Thank you!
Stephanie Herr
Product Manager - Database DevOps
-
3 votes
An error occurred while saving the comment Did you try to add an Include filter for this function (Setup | Edit filter rules | Include if: ...)?
-
16 votes
-
4 votes
-
15 votes
you can unformat to remove tab / space / crlf in the selected text and change it into a single line (it ensures, that there is one space when replacing crlf, so your code won't break).
Not exactly what you want, but helps a lot (e.g. when you have a long IN()-List or to wrap the column list in an INSERT statement