Activity overview
Latest activity by aGoram
JOIN CONDITION
on suggestion for join : Is it possible to haveSELECT *
FROM table1 a
JOIN table2 b on b.id = a.id
-- instead of
SELECT *
FROM table1 a
JOIN table2 b on a.id = b.id
in my opinion , after th...
Format insert into
v4 is really great, but one this is bugging me
i already said something about this, but it really frustate me :
in V3 :INSERT INTO TABLE1 (
COL1,
COL2,
COL3,
COL4
) VALUES (
/* CO...
Perfect ! / comments
Perfect !
Thanks for the fast reply. i didn't know because on the website it's still 4.0, so i thought it was the same release as weeks ago.
And for the next correction of bugs ? do i need additional option support and upgrades package ? / comments
Thanks for the fast reply. i didn't know because on the website it's still 4.0, so i thought it was the same release as weeks ago.
And for the next correction of bugs ? do i need additional option ...
tanya wrote:
Hello all,
Guilty as charged [image]
In the process of redesigning the options dialog, we missed retaining the default indentation behaviour for SQL Prompt v4. This is a bug and we will fix it in our next release. Until then, I am afraid we do not have any workaround unless any of you can come up with an ingenious solution [image]
Sincere apologies for the inconvenience this has caused.
Thanks,
Tanya
Project Manager
Red Gate Software Ltd
I have a quick question.
If i buy the v4 pro , do i need the additional option support and upgrades package to have the next release (with bug corrected)? / comments
tanya wrote:
Hello all,
Guilty as charged
In the process of redesigning the options dialog, we missed retaining the default indentation behaviour for SQL Prompt v4. This is a bug and we will fix...
one other things
i can't have suggestion for SP on a new line alter i type ap_
for exemple : select * from emp
ap_
but this work select * from emp
go
ap_
it was fine on v3... / comments
one other things
i can't have suggestion for SP on a new line alter i type ap_
for exemple :select * from emp
ap_
but this workselect * from emp
go
ap_
it was fine on v3...
Thanks a lot. / comments
Thanks a lot.
1 and 2 are check
and if i type exec <control+space> or alter procedure <control+space> it works.
But exec sp_helptext <control+space> doesn't work anymore in v4.
too bad, because it's very usefull to have a quick view on a SP / comments
1 and 2 are check
and if i type exec <control+space> or alter procedure <control+space> it works.
But exec sp_helptext <control+space> doesn't work anymore in v4.
too bad, because it's very usefull...
SP suggestion
Im not able to have suggestion for stored procedure
exec sp_helptext <control+space> was working in v3
am i missing an option ?
Thanks for the response.
I found the option i was looking for : Each subsequent column.
But the thing is : it make the layout i want for the insert into statement but it change the layout of the select statement.
I mean what a want is this : SELECT staffId
, staffName
, a
, DAY(@dateOnly)
FROM dbo.personnel
INSERT INTO mytable(CODE
, NAME
,ACTIVE
, DESCRIPTION
)
VALUES (NULL, -- CODE - nvarchar(50)
NULL, -- NAME - nvarchar(80)
'', -- ACTIVE - char(1)
NULL, -- DESCRIPTION - nvarchar(1500)
)
anyway thanks again / comments
Thanks for the response.
I found the option i was looking for : Each subsequent column.
But the thing is : it make the layout i want for the insert into statement but it change the layout of the se...