Comments
Sort by recent activity
Hey Alex - no particular reason specific to computed columns, we usually qualify object names (and use SQL Prompt to auto-format all code to use it) in general, which means it's probably getting introduced at some point in the development process and then just carried through to the table definition.
/ comments
Hey Alex - no particular reason specific to computed columns, we usually qualify object names (and use SQL Prompt to auto-format all code to use it) in general, which means it's probably getting in...
Since the code formatter appears not to have liked my line breaks, I'm pasting the relevant script here in an unformatted block:
CREATE TABLE dbo.RG_Recovery_1_FactChecklistCompletion ( ChecklistCompletion_SK INT NOT NULL IDENTITY(1, 1) ,ChecklistItem_SK INT NOT NULL ,Person_SK INT NOT NULL ,ChecklistItemCompletionDate DATETIME2(3) NULL ,ChecklistItemCompletionDateKey AS (CONVERT(INT, CONVERT(CHAR(8), FactChecklistCompletion.ChecklistItemCompletionDate, (112)), (0))) ) GO
/ comments
Since the code formatter appears not to have liked my line breaks, I'm pasting the relevant script here in an unformatted block:
CREATE TABLE dbo.RG_Recovery_1_FactChecklistCompletion ( ...
@Alex B , that's incredibly helpful - thanks for the code snip, it's going to potentially save us a lot of trouble.
Is that something you think will get integrated into the product itself at some point?
/ comments
@Alex B , that's incredibly helpful - thanks for the code snip, it's going to potentially save us a lot of trouble.
Is that something you think will get integrated into the product itself at some ...
@Alex B , thanks for the answer!
I'm running 10.1.0.13908 at the moment, and it's still displaying the behavior described. .
Probably not relevant, but oddly enough I don't see that version number on the page you linked to - it only goes up to 9.5.23
/ comments
@Alex B , thanks for the answer!
I'm running 10.1.0.13908 at the moment, and it's still displaying the behavior described. .
Probably not relevant, but oddly enough I don't see that version numbe...
DBTL said:
dufflepud said:
Is this still not on the road map? I would imagine this is becoming more and more of an issue for people.
Certainly is for me. Without support for MFA, I cannot condone the use of Redgate products to my clients anymore.
Echoing this sentiment, it's been great to see MFA added to several other Redgate products but this one is a really useful feature that's unfortunately no longer available to us. / comments
DBTL said:
dufflepud said:
Is this still not on the road map? I would imagine this is becoming more and more of an issue for people.
Certainly is for me.Without support for MFA, I c...
Clarifying note, the error happens when I try to format a script that contains both of the above queries, when both queries contain a HAVING and FOR SYSTEM_TIME. / comments
Clarifying note, the error happens when I try to format a script that contains both of the above queries, when both queries contain a HAVING and FOR SYSTEM_TIME.
@Tianjiao_Li, thanks for your help.
I am on version 9.4.3.7121. I do have a custom format style, but I get the same error when I use the Default format style: were you testing it with both statements?
[image]
/ comments
@Tianjiao_Li, thanks for your help.
I am on version 9.4.3.7121. I do have a custom format style, but I get the same error when I use the Default format style: were you testing it with both statem...
Clarifying note, the error happens when I try to format a script that contains both of the above queries, when both queries contain a HAVING and FOR SYSTEM_TIME. / comments
Clarifying note, the error happens when I try to format a script that contains both of the above queries, when both queries contain a HAVING and FOR SYSTEM_TIME.
That would be great, Mark: both of those sound like really important features.
Am I understanding you correctly in saying that you would regard creating both the base and history tables in a non-default schema to be a customization? I'm not clear on whether the problem is caused by the fact that the tables aren't in the 'dbo' schema, or by the fact that I used Owner Mapping to put the tables in a different target schema than the source. / comments
That would be great, Mark: both of those sound like really important features.
Am I understanding you correctly in saying that you would regard creating both the base and history tables in a non-de...
When text is highlighted, hitting the Ctrl key will bring up the dialog box. Typing, such as commas, will filter down the list of actions to what you want.
So, with text highlighted, I hit Ctrl, type 'comma', and then hit Enter. / comments
When text is highlighted, hitting the Ctrl key will bring up the dialog box. Typing, such as commas, will filter down the list of actions to what you want.
So, with text highlighted, I hit Ctrl, t...