Comments
Sort by recent activity
Bart Read wrote:
So for example you could set it up in the options dialog to ignore prefixes such as "T_", "V_" etc.
Would this do the trick?
Yes, that would definitely be an option - specify some prefixes to ignore, or a number of chars to ignore.
Even better would be a way to specify manually, on a table-by-table (and view-by-view) basis, what prefixes to use. Fill those in with your best guess, but allow me to change them where appropriate and needed.
Thanks!
Marc / comments
Bart Read wrote:
So for example you could set it up in the options dialog to ignore prefixes such as "T_", "V_" etc.
Would this do the trick?
Yes, that would definitely be an option - specify s...
Bart Read wrote:
Please see my post in reply to your topic about owner/schema names: the same thing applies. We just didn't have time to fix this for the beta.
Thanks - yes, I noticed a "known issue" in the release notes, too, later on. Hope it'll be fixed in Beta 2! :-)
Marc / comments
Bart Read wrote:
Please see my post in reply to your topic about owner/schema names: the same thing applies. We just didn't have time to fix this for the beta.
Thanks - yes, I noticed a "known ...
I was a bit saddened to hear about the "final preview version" of SQL Prompt 5 being out, and this issue is **STILL** **NOT** **FIXED** ....... / comments
I was a bit saddened to hear about the "final preview version" of SQL Prompt 5 being out, and this issue is **STILL** **NOT** **FIXED** .......
The problem has been solved in a very competent manner by Red Gate support. There must have been some "gremlin" in my computer that interfered with the update process.
After uninstall and reinstall and re-update, everything works fine - thanks to Red Gate's excellent support! / comments
The problem has been solved in a very competent manner by Red Gate support. There must have been some "gremlin" in my computer that interfered with the update process.
After uninstall and reinstall...
Brian,
thanks for your help - my direct report with Red-Gate support has resulted in a case (F0033534) being worked on already. I sent Chris Auckland some error logs and observations - hope he'll be able to figure out the root cause of this problem somehow - I'm confident he will !
Thanks!
Marc / comments
Brian,
thanks for your help - my direct report with Red-Gate support has resulted in a case (F0033534) being worked on already. I sent Chris Auckland some error logs and observations - hope he'll b...
Anu Deshpande wrote:
But SQL Prompt doesn't add the computed columns in 'insert into' statements.
Ah - yes it does ! (but it shouldn't)
Try this: SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DocumentStore](
[ID] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY,
[DocFileName] [varchar](255) NULL,
[DocContent] [image] NULL,
[DocLength] AS (datalength([DocContent])) PERSISTED,
)
GO
SET ANSI_PADDING OFF
GO
When I go ahead and type INSERT INTO dbo.DocumentStore
and how I press <ENTER> on my keyboard, this gets expanded into: INSERT INTO dbo.DocumentStore
( DocFileName ,
DocContent ,
DocLength
)
VALUES ( '' , -- DocFileName - varchar(255)
NULL , -- DocContent - image
0 -- DocLength - int
)
and quite clearly, the "DocLength" column is a computed column and there's really absolutely no point for me to insert a value into that column!
SQL Prompt 4.0.3.10 on SQL Server 2008 / comments
Anu Deshpande wrote:
But SQL Prompt doesn't add the computed columns in 'insert into' statements.
Ah - yes it does ! (but it shouldn't)
Try this:SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ...
Anu Deshpande wrote:
Ah ha I see what is happening!
Can you kindly update your version to 4.0.4.11?
Kindly let me know whether it fixes the issue or not.
Yes, that definitely solves that problem - thanks!
Marc / comments
Anu Deshpande wrote:
Ah ha I see what is happening!
Can you kindly update your version to 4.0.4.11?
Kindly let me know whether it fixes the issue or not.
Yes, that definitely solves that probl...
Thorsten,
I've been pestering Red Gate about this behavior ever since they took over SQL Prompt - without any success, so far :-( Glad to see another user also seems to agree this is an issue that needs to be fixed ASAP.
See this thread here - an "enhancement request" has already been logged - express your interest in it, then we might get them to finally fix it some day!! http://www.red-gate.com/MessageBoard/vi ... php?t=9434 / comments
Thorsten,
I've been pestering Red Gate about this behavior ever since they took over SQL Prompt - without any success, so far :-( Glad to see another user also seems to agree this is an issue that...
This issue seems to have been fixed with this new cummulative patch release: http://www.red-gate.com/MessageBoard/vi ... hp?t=10248
At least in my cases, everything works as expected now, with this new patch version. / comments
This issue seems to have been fixed with this new cummulative patch release:http://www.red-gate.com/MessageBoard/vi ... hp?t=10248
At least in my cases, everything works as expected now, with this ...
I agree - having computed columns in the list of fields of an expanded INSERT statement makes no sense at all.
Same goes for columns of type TIMESTAMP or ROWVERSION - one can never insert a value into those - so why put them in the list of fields of an INSERT statement in the first place?? / comments
I agree - having computed columns in the list of fields of an expanded INSERT statement makes no sense at all.
Same goes for columns of type TIMESTAMP or ROWVERSION - one can never insert a value i...