Settings and activity
18 results found
-
8 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
-
636 votes
Hi everyone. I have merged some User Voice items on this topic of “filtered” static data, as there was significant overlap. I want to share our current guidance on handling scenarios where you need to version a subset of the columns and/or rows in the table.
With SQL Source control, the best option at this point is to use a post-deployment script for this purpose.
SQL Source Control introduced pre- and post- scripts in v6.3.
A post-deployment script gives you a good amount of flexibility over exactly which rows or columns of data you want to include in your project. Example post-deployment scripts for static data are here: https://documentation.red-gate.com/soc7/common-tasks/working-with-pre-post-deployment-scripts/static-data
If you make heavy use of Static Data, we have stronger support for this in SQL Change Automation.
SQL Change Automation:
- Supports column filtered static data tables in the SCA plugin in SSMS
- Supports multiple post-deployment scripts, in case there is…
-
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