Posts
Sort by recent activity
bug when changing a PROCEDURE to a FUNCTION
When I convert some already created procedure for example
CREATE PROC IsWasAlreadyClosed(@Call_ID int)
and convert it to
CREATE FUNCTION IsWasAlreadyClosed(@Call_ID int)
When I try to sync the data...
ALTER statements bug
I'm not sure if it's a bug, but it don't seem very usefull them.
When using the ALTER statements features I could write
ALTER PROC getEmploye <then press my completion key>
and the whole getEmploye...
WHERE Clause suggestion
I hope I'm not to late for suggesting this kind of feature for the 8.0
But there's something i'm doing very often in each application : a table 'Parameter'.
This table hold every parameters for the...
FeedBack SQL Compare 8 Beta
Ok here's is the feedback from SQL Compare 8 beta, I'm currently using SQL Compare 6.
First thing I observed is the comparaison projects wizard that changed, the script open is the last one used an...
When using Table hint the candidate list don't work
When using this syntax
SELECT * FROM TableName WITH (NOLOCK) WHERE
it work fine
but if I use this syntax (omiting the optional WITH)
SELECT * FROM TableName (NOLOCK) WHERE
It won't display the fiel...
SQL Prompt 3.9 selection bug with SSMS
There's a new bug in SQL Prompt 3.9 with SQL Server Management Studio (SQL2005).
The selection word delimiter is wrong for SQL script when double-clicking a word and selecting it
Example :
I type t...
[BUG] Wheel mouse zoom not working on secondary monitor
When zooming with the mouse wheel on my primary monitor (I'm using dual display) the layout is zoomed in or out.
when I move the SQL Dependency Tracker to my secondary monitor (at left of the prima...
[FR] Cachement management Exclude databases
I would be great to add an option to exclude database from automatic caching, if you want the automatic refresh on small database and manual on the large one
Prompt window size and double quote
It would be nice if SQL Prompt could be able to save the last window size used as a per database settings. because I always set the window bigger but when I create a new SQL script the size is back...
Compare Relations Diagram
Is it possible to compare and synchronize the relations diagram created ?