Posts
Sort by recent activity
Semicolum bug in 6.4.0.633
Repo:
DECLARE @cmd VARCHAR(1000);
DECLARE @filelist TABLE (filelist_name VARCHAR(255));
SET @cmd = 'dir /B /A:-D';
INSERT INTO @filelist
(filelist_name)
EXEC master.sys.xp_cmdsh...
JOIN formatting bug in 6.4.0.633
Repo:
IF OBJECT_ID('tempdb..#a') IS NOT NULL
DROP TABLE #a
IF OBJECT_ID('tempdb..#b') IS NOT NULL
DROP TABLE #b
CREATE TABLE #a (id INT IDENTITY(1, 1)
...
Bug in 6.4.0.633
Repo:
IF b = 0
BEGIN
IF @a = 0
BEGIN
PRINT '0'
IF @a = 0
PRINT '0'
END
ELSE
BEGIN
PRINT 'not 0'
END
END
If I disable "Indent BEGIN...END blocks and then format the SQ...
Feature request
I'm currently going through a refactoring exercise and utilize SQL Data Compare extensively. However, I am getting too many (in my mind) false positives due to the refactoring.
I'd therefore like t...
Feature requests to support refactoring
I'm currently going through a refactoring exercise and utilize SQL Compare extensively. However, I am getting too many (in my mind) false positives due to the refactoring.
I'd therefore like to sug...
SQL Compare 10.2.0.916 and SQL Server 2000
When SQL Compare starts to register the data sources of a SQL Server 2000 database it aborts with an error message of "Specified cast is not valid" when reading table columns.
Using SQL Compare 9.5...
SQL Compare 10.2.0.916 "Check for Update..." broken
SQL Compare 10.2.0.916 "Check for Update..." broken with error message "Could not find any resources appropriate for the specified culture or the neutral culture. Make sure "#ibg.#kbg.resources" w...
Indenting of BEGIN/END
I don't seem to be able to suppress the indenting of BEGIN/END statements. What I'd like to achieve is the following formatting:
IF (SELECT AVG(price) FROM titles WHERE type = 'mod_cook...
SQL Prompt and permissions
Trying to write queries against production databases where I'm limited to read-only database user roels SQL Prompt generates various permissions errors as quoted below. This doe snot happen on deve...
Multi-word capitalizing problem
When typing code like "UNION ALL" or "CREATE TABLE" with syntax option set to all caps it does not capitalize the first word but only the second one.
Example: Typing "create" will then list the var...