Activity overview
Latest activity by shawndevin
Also the CTE statement formatting: Put the parenthesis inline with the first statement, closing paren on a new line but indent the contents from the left edge / comments
Also the CTE statement formatting: Put the parenthesis inline with the first statement, closing paren on a new line but indent the contents from the left edge
the same would be true for indenting the content of the schema: CREATE TABLE Production.BillOfMaterials ( BillOfMaterialsID INT IDENTITY(1, 1) NOT NULL PRIMARY KEY NONCLUSTERED(BillOfMaterialsID ASC) ,ProductAssemblyID INT NULL ,ComponentID INT NOT NULL ,UnitMeasureCode NCHAR(3) NOT NULL FOREIGN KEY REFERENCES UnitMeasures(ID, Code) ) ON [PRIMARY] GRANT EXECUTE ON LogEvent TO ts_webapplication; ALTER AUTHORIZATION ON OBJECT::Production.ProductionView006 TO SCHEMA OWNER; / comments
the same would be true for indenting the content of the schema:CREATE TABLE Production.BillOfMaterials ( BillOfMaterialsID INT IDENTITY(1, 1) NOT NULL PRIMARY KEY NONCLUSTERED(BillOfMaterialsID ...
suggestion - sql promt edit style for Parenthesis should allow one more style
would it be possible to add one more style to the edit style page for Parentheses? I would like the inline ( but have the sql code indented. for example:SET @recent=( select top 1 name from...
[image] [image] [image] Sql search 3.6 won't install under ssms 19.0 / comments
Sql search 3.6 won't install under ssms 19.0