ApexSQL Complete 2013 R4 – Product update alert

ApexSQL Complete 2013 R4 has been released

Type: Maintenance release

About ApexSQL Complete: ApexSQL Complete is a FREE SQL Server Management Studio and Visual Studio add-in, which speeds the process of coding. It completes SQL code statements automatically, fills in SQL code fragments, highlights syntax errors and much more

For more information, visit the ApexSQL Complete product page

About this release:

• Reworked and improved 200+ hint-list templates, most notably
  • Column hints for SELECT tablename
  • Table hints for SELECT columnname INTO
  • Removed column hints for SELECT * FROM
  • Variable hints for SELECT * FROM OPENXML(
  • Only keyword hints for SELECT ProductID, GETDATE() FROM(
  • Variable hints for SELECT * FROM tablename OPTION(OPTIMIZE FOR (
  • Appropriate keywords for …OPTION(TABLE HINT (tablename,
  • Index hints for …OPTION (TABLE HINT (tablename, FORCESEEK(
  • Column hints for …OPTION (TABLE HINT(tablename, FORCESEEK(indexname(
  • Index hints for …OPTION (TABLE HINT(tablename, INDEX(
  • Linked server hints for INSERT OPENQUERY(
  • Keyword hints for INSERT OPENROWSET(BULK ‘s’,
  • Keyword hints for INSERT OPENROWSET(BULK ‘s’, FORMATFILE = ‘ss’ ,
  • Keyword hints (CURSOR,XML…) for DECLARE @variablename
  • Linked server hints and table – valued functions hints for DELETE statement
  • Table – valued functions hints for UPDATE statement
  • Keyword hints for
    UPDATE tablename
    SET columnname = 1
  • Keyword hints for
    UPDATE tablename
    SET columnname = 1 [FROM] [WHERE] OPTION(
  • xmlschemaname hints for CREATE TABLE tableName (columnName xml ([CONTENT] [DOCUMENT]
  • IDENTITY keyword hidden ( IDENTITY keyword only for tinyint, smallint, int, bigint, decimal(p,0), or numeric(p,0) columns.) for CREATE TABLE dbo.Test (columnName nvarchar(200)
  • Partition schema hints for cases:

    CREATE TABLE tableName
    (
    columnName int PRIMARY KEY,
    CONSTRAINT constraintName UNIQUE CLUSTERED (columnName) ON – Partition schema hints
    )

  • Column hints for
    ALTER TABLE tableName
    ADD columnName FOREIGN KEY REFERENCES tableName (
  • Table hints for
    ALTER TABLE tableName
    ADD COLUMN [NULL\NOT NULL] [CONSTRAINT C] FOREIGN KEY REFERENCES
  • Column hints for
    ALTER TABLE tableName
    ADD COLUMN [NULL\NOT NULL] [CONSTRAINT C] FOREIGN KEY REFERENCES tableName (
  • Appropriate keywords, filegroups and partition schemas hints:
    CREATE TABLE tableName
    (
    columnName int
    )
    [ON] – Appropriate keywords, filegroups and partition schemas with partition columns hints
    [TEXTIMAGE_ON] – Appropriate keywords, filegroups and partition schemas hints
    [FILESTREAM_ON] – Appropriate keywords, filegroups and partition schemas hints
  • For ALTER VIEW – Removed unnecessary hints
  • For ALTER SCHEMA schemaName – Removed unnecessary hints
  • For ALTER PROCEDURE procName – Removed unnecessary hints
  • For ENABLE\DISABLE TRIGGER triggerName – Removed unnecessary hints
  • For DECLARE @DBNAME VARCHAR(50)
    SET @DBNAME = ‘TEST’;
    DECLARE @MyDate date;
    BACKUP DATABASE – Show database hints automatically
    READ_WRITE_FILEGROUPS TO DISK = – Removed unnecessary hints and added variable hints
    WITH EXPIREDATE = – Removed unnecessary hints and added variable hints
  • Schema hints:
    ALTER APPLICATION ROLE approle WITH NAME = appname, PASSWORD = ‘apppass’,
    DEFAULT_SCHEMA =
  • Symmetric and asymmetric keys hints:
    ALTER SYMMETRIC KEY symmetricKeyName
    ADD ENCRYPTION BY PASSWORD = ‘asd’,
    CERTIFICATE – Certificate hints,
    SYMMETRIC KEY – Symmetric keys hints
    ASYMMETRIC KEY – Asymmetric keys hints
  • Services and queue hints:
    ALTER SERVICE – All services hints
    ON QUEUE – Queue hints
  • For ALTER SERVICE serviceName
    ([ADD CONTRACT] – Contract hints
    [DROP CONTRACT] – Contract hints
  • Table hints for REVOKE [ GRANT OPTION FOR ] REFERENCES ON OBJECT::
  • Table columns hints for REVOKE [ GRANT OPTION FOR ] REFERENCES ON OBJECT:: tableName (
  • Database hints for ALTER LOGIN login_name WITH DEFAULT_DATABASE =
  • Credential hints for ALTER LOGIN login_name WITH CREDENTIALS =
  • Filegroup hints for
    ALTER FUNCTION funcName ()
    RETURNS @tabVa TABLE(c1 int PRIMARY KEY ON
  • Constraints keywords for DECLARE @var AS TABLE(
  • Column hints for CREATE INDEX indexName ON PartitionTable (AddressLine1, FirstName ASC) ON myRangePS1(
  • Column hints for ALTER FULLTEXT INDEX ON Person.Address ADD(
  • Sequence hints for DROP SEQUENCE name,
  • Index hints for MERGE Production.UnitMeasure WITH (INDEX(
  • Column hints for BULK INSERT t FROM ‘path’ WITH (ORDER (
  • Auto table hints for CREATE STATISTICS asd ON
  • Column hints for CREATE STATISTICS asd ON tableName(columnName,
  • User hints for DENY ALL TO
  • User hints for DENY ALL ON tableName TO
  • Hint – list ordering for
    UPDATE STATISTICS t – <index, statistics, keys>
    CREATE FULLTEXT STOPLIST asd FROM – <stoplist, database, keywords>
    DROP AGGREGATE – <aggregate, schema>
    DROP DEFAULT – <default, schema>
    DROP PROC and DROP PROCEDURE – <procedure, schema>
    DROP QUEUE – <QUEUE, schema, db>
    DROP RULE – <rule, schema>
    DROP SYNONYM – <synonym, schema>
    DROP XML SCHEMA COLLECTION – <xml, schema>
    DROP SEQUENCE – <sequence, schema, db>
    DROP TRIGGER – <trigger, schema>
    DROP INDEX{0} i on t WITH ({1}MOVE TO ps(<column_hints>
• Hint-list ordering is now based on context
• Performance improvement in processing typed characters and keyboard typing response speed is up by 50%
• Hint-list can now be made transparent by pressing CTRL
• Custom shortcuts for commands can now be defined
• Changes:
  • Default shortcut keys combination for the Insert snippet command is now ‘Ctrl+Shift+Alt+N’
  • Default shortcut keys combination for the Enable Auto-replacement command is now ‘Ctrl+Shift+Alt+J’
  • Default shortcut keys combination for the Show Error list command is now ‘Ctrl+Shift+Alt+I’
  • Default shortcut keys combination for the Syntax Error Highlighting command is now ‘Ctrl+Shift+Alt+P’
• More than 15 bugs fixed

See also:

Release notes